We have an application group that wants to pull date from SQL Server and =
write it to text file on the server. They want the file format to be =
12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for a =
second set...and so on. The '12100' is fixed, but the rest of the file =
name will always have to include the system date/time. Is there an easy =
way to do this within a DTS package (when writing to the output file)? =20

Hi

You can set a global variable to the fixed part at the start of the =
process. This should help http://www.sqldts.com/default.aspx?200 =
although you want to set a global variable rather than a local one.=20


John
[quoted text, click to view]
We have an application group that wants to pull date from SQL Server =
and write it to text file on the server. They want the file format to =
be 12100_YYYMMDDHHMM.fr1 for one set of data, 12100_YYYMMDDHHMM.fr2 for =
a second set...and so on. The '12100' is fixed, but the rest of the =
file name will always have to include the system date/time. Is there an =
easy way to do this within a DTS package (when writing to the output =
file)? =20