sql server dts: Export data to different text files -- sql server dts

Export data to different text files

Eduardo Greco
7/27/2004 10:59:07 PM

sql server dts:

Hi there!
I want to export data to file texts based on parameters that come from a
second table.

For example:
select * from table1
where field = ?parameter?
But:
?parameter? are all values from another table.

For each different value of ?parameter? I want to create a new text file.
I hope it's clear enough.
Thanks.

Re: Export data to different text files

Allan Mitchell
7/28/2004 7:53:29 AM

Ok so it sounds to me like you want to loop

In that loop you change the value of ?
AND you change the location of the text file

These articles will get you most of the way there.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]