Avatar of Dick Rosenberg
Dick Rosenberg
 asked on

SSIS problem creating multiline DOS batch file

Hi,

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?

Thanks,

Dick
SSIS

Avatar of undefined
Last Comment
Dick Rosenberg

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dick Rosenberg

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck