General information
Forum:
Microsoft SQL Server
Title:
Picking up files in a directory
Environment versions
SQL Server:
SQL Server 2005
Hi
I've created a dtsx package to import a csv file.
The import filename is effectively hard coded into the dtsx package.
How can I make the package pick the oldest file in a folder.
the folder is where incoming csv files will be placed and I want a job to be picking up the files from that folder and processing them before moving the file to a backup location.
Any tips or ideas are welcome
Thanks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only