create text file and export

[sedgely]

i have a query that returns several rows of data, i need to export this out to a text file. i have done this several times before but always to an existing text file. is there anyway i can create a new text file from within DTS using one of the values from the returned data as the filename?

Cheers, Craig
Si fractum non sit, noli id reficere

 

[mrdenny]

Check some of the other posts in this forum. There are a few example of using a dynamic properties task to change the destination file name to a dynamic name.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com