CopyFile? Is there an AppendFile?

[jsblakley]

I have a DTS package that copy flat files to a common directory, then copy the multiple flat files into one flat file. From there we will import the data into our database.

Any suggestgions?

 

[JayKusch]

A bit confused here ... DO you have a DTS package that is already doing the actions described OR are you looking for a way for a DTS package to accomplish what you posted above?

Thanks

J. Kusch

 

[jsblakley]

I have an existing package, but I need to figure out how to append to a flat file.

Thanks!
Jeff

 

[JayKusch]

If you are trying to append all of your files you have gather into 1 file, and for sake of argument they are all to be text files, then you probably want to create an "Execute SQL Task" object. In there you could use an

EXEC
master..xp_cmdshell 'COPY C:\WhatEverDir\*.txt AllFiles.txt'

Is this what you are after?

Thanks

J. Kusch