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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 ftp (exporting not importing) with dts

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-19 : 22:58:42
James writes "I am calling ftp.exe from dts (using Execute Process Task) which works fine, but I cannot detect when it fails. (ftp.exe does not appear to raise an error and dts always thinks everything has gone OK.

Is this possible without using xp_cmdshell which I am loathed to do. I am not sure if I can trap all ftp errors even then.

I am using SQL 2000"
   

- Advertisement -