Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS FTP transfer date and timestamp filename

Status
Not open for further replies.

mahi2016

Programmer
May 2, 2016
1
US
Hello,

I have an ssis package with filename format as xxxxx_201605020937 (date and timestamp). There will be 2 files on Friday with same format but different timestamp. A job agent is set up to process these files on Saturday morning 1:00am.

I am looking for a solution to fetch these files which are loaded few seconds apart from FTP.

Thanks
MSN
 
Create a ForEach Loop Container. Set your "collection" property to xxxxx_.* Then put all your processing within this container. It will pick up each file matching the collection pattern and put it through the tasks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top