dbTalk Databases Forums  

Odd FTP task problem

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


Discuss Odd FTP task problem in the microsoft.public.sqlserver.dts forum.



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

Default Odd FTP task problem - 03-09-2006 , 04:17 PM






I have added an FTP task to my package. It works fine; I am able to connect
to the source, select files and FTP to the desitination.

However, the name of the file won't always be known when the package runs.
An activeX script derives the name and stores it as a global variable. This
global variable is then used by a Dynamic Properties task as input to the FTP
task. It does not work. I get an error: Failed to connect to internet site
for file transfer.

If I open up the FTP task I can see the correct file name in the list of
files to be ftp'd.

Any ideas?

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.