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 |
|
rbohaty
Yak Posting Veteran
71 Posts |
 Posted - 2005-11-28 : 11:47:39
|
| I want to use ftp within a DTS package to retrieve a file from a remote ftp server. I can setup the ftp task and get the file, what I would like to know is how to do error checking..ie: file not found on server. The package is clasified as successful even though no file is available to download...Thanx in advance.... |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2005-11-28 : 11:50:47
|
| Not sure how to get a "FileExists" command in FTP but I would figure that setting a global variable with a true or false and then checking that variable in the activex script to set the package to fail or not depending on the dts global variable.________________________________________________Drinking German Beer... fun.Listening to an accordian player play ACDC...priceless |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-28 : 11:59:10
|
| Not using dts but have a look athttp://www.mindsdoor.net/FTP/s_ftp_GetDir.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Using FTP within DTS package