Sequencing file output w/ SQL

[rute67]

I am USING a DTS package to create an automatic output file every month. I need to be able to sequence that out file name.

For example:

products20030401.txt (current month)
products20030501.txt (Following Month)

Is this possible and if so how?

Thank you very much for your help.

 

[tlbroadbent]

See the article at SQLDTS.com.

How can I change the filename for a text file connection?

http://www.sqldts.com/default.aspx?6,101,200,0,1

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm