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.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.