Hi, I am still new to DTS and can't figure out how to do this.

I have a two tables, Game and Game Detail joined by Game_ID, I need to set
up a DTS package where I can export to different text files the Game Detail
information for each game in the Game table. Each Text file will be the Game
detail information for the unique game_id and the files need to be name as
such.

Game_ID = 1 gives game1.txt
Game_ID = 2 gives game2.txt and so on.

Thanks in advance

Tim

OK So you are going to have to involve some kind of loop, dynamic setting of
the SourceSQLStatement and setting of the Filename.

These will help

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


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


How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Tim Hanson" <Tim Hanson (AT) discussions (DOT) microsoft.com> wrote

Thank you Allan, that worked great.

Tim.

"Allan Mitchell" wrote: