Hi,

I need to read in a global variable to name my output
files. Then I need to create a new file for each product
in the table, and name the file by the product name and
the value of the parameter.

For example, if the parameter is 12/31/2003, I would need
to create a file called ProductName12312003.txt

I am new to DTS and would appreciate any help.

Thanks,

In article <0bb401c3be7b$b5f34620$a001280a (AT) phx (DOT) gbl>, Elaine Paula
<elaine.paula (AT) sunlife (DOT) com> writes
This shows how to change a text file connection-
How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

Not sure exactly how the one file per product works, but this might
help-
How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

Depending on exactly what you mean you may also want to have a look at
the Write File Transform.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org