Avatar of OceanReefClub
Flag for United States of America

asked on 

Use GetDate to name export .txt file?

I'm building a package in BIDS for exporting a view into a .txt file.

i'd like the package to run every day and create a separate .txt file for each day, as they are imported thereafter into ACT.

in my Package, i use an OLE DB Source to gather the recordset, and a Flat File Destination to output it to .txt file. How can I have the .txt file's name have a DATE in it so they don't get overwritten each time the package is run?
Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
Mike Lazarus

8/22/2022 - Mon