I have a DTS with one conection and two destination text files. I need
to transform this two text files into one text file (first one files
date and under the other files data)

How can I do this?



*** Sent via Developersdex http://www.developersdex.com ***

Marcela Cure wrote:
Run the package twice, or concatenate the files first, and process the
result. You can concatenate with the DOS copy command e.g.

copy file1.txt+file2.txt file3.txt


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

I am trying to concatenate (its not 2 but 3 files) the files using a
batch file which I tried and worked. But the problem now is where two
put it in the DTS. I have one Connection and three destination text
files. After they have all completed converting into text files the
batch (with execution process job) should run, how can I put the batch
to run after the completion of the three jobs?



*** Sent via Developersdex http://www.developersdex.com ***

Marcela Cure wrote:
Use Workflow constraints akey precedence constraints to ensure the order
of execution. Use On Success from each DataPump to the Exec Process Task.

Also ensure you set Close Connection on completion on the DataPump task,
right-click - Workflow Properties - Options.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com