dbTalk Databases Forums  

FTP Error whilst using a structured storage file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss FTP Error whilst using a structured storage file in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andy
 
Posts: n/a

Default FTP Error whilst using a structured storage file - 08-11-2004 , 06:13 AM






I am trying to FTP a file using a Structured Storage File.

I am using BCP to export a file to a directory and then FTP'ing this file to
another server. It works fine in design mode the first time i run it but when
i try to run it again it fails. I have installed SP3 which several sites have
stated should fix this porblem but it did not.

When i try to run the file using DTSRUN it always fails with the error message

error DTSStep_DTSCreateProcessTask_2 -2147220330 : process returns code 2
which does not match the SucessReturnCode of 0

Do you know why this FTP is failing when i use DTSRUN?

Thanks
Andy

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.