May 9, 2013 at 10:39 am
I have an FTP command file that I want to open in a data flow and then using a Script Component find the "get" command and dynamically assign a variable value for the <filename> that is to be downloaded from the FTP Site. Problem seems that I cannot use the same actual flat file for Source and Destination. So I guess that I have to have two files a "script template file" for source and the actual "script file" for destination? Is this really the best way? Better alternatives?
May 10, 2013 at 1:23 am
kurt.whaley (5/9/2013)
I have an FTP command file that I want to open in a data flow and then using a Script Component find the "get" command and dynamically assign a variable value for the <filename> that is to be downloaded from the FTP Site. Problem seems that I cannot use the same actual flat file for Source and Destination. So I guess that I have to have two files a "script template file" for source and the actual "script file" for destination? Is this really the best way? Better alternatives?
I would not recommend a data flow for this. Instead, a Script Task could be used to open, modify and save the file.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply