I have to create a multiline DOS batch file in SSIS that looks like this:
cd e:\client\data
copy generic_output.txt clientname.yyyymmdd (yyyymmdd is today's date)
I have created quite a few single line DOS copy statements that do the copy (using a Derived column in the Data Flow) but can't come up with an approach that will allow me to create a template file that contains the (hardcoded) first line and then have a Data Flow task that writes out the first line and then have the Derived column be the second line.
Can I write out both commands in the Derived Column and put in a CR-LF in between the cd command and the copy command? Or is there a better approach?