Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2001-09-24 : 05:55:01
|
| Using DTSI want to ftp a file using DTSI have set up the FTP task and this works fine (as a single step)I have set up Dynamic Properties and can set the password fine.I am having trouble with the SourceFileName, i am setting it with a query (I will be pulling different files down, but am testing with "select 'ewm.bak'")When I run the package this fails with the error message "invalid string format for source file names"When I look at the ftp task the file name is the file list; if I OK the ftp task and execute the step, it works fine (the file is ftp'd down). So as a package it fails, but looking at the single step and OK'ing it works ...What am I doing wrong -- how do I get a file name into the sourcefilename successfully?Any help/pointers appreciated |
|
|
|
|
|
dts & ftp & invalid string format