Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Pull most recent xlsx file from folder

Author  Topic 

mgreen84
Yak Posting Veteran

94 Posts

Posted - 2014-11-14 : 10:29:23
How Can I pull the most recent excel file from a folder in SSIS?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-14 : 10:49:58
Here's one approach:

http://microsoft-ssis.blogspot.ca/2011/04/how-to-configure-foreach-loop-container.html

The idea is to get the most recent file using a Script component, put it in a variable, then process that file using the variable as the file name
Go to Top of Page
   

- Advertisement -