Foreach loopcontainer to load file which contains the string %vendor%
Hi,
In my SSIS package I am using Foreach loopcontainer to load multiple flat files.
Now my requirement is that I want to load only those file which contains %vendor%.In source folder I have many files but I am interested in to load only those file which contains the string %vendor% in file name.
August 25th, 2015 11:53pm
Before trying out any third party suggestions here. Try to import all files (*.csv) and then filter them using precedence constraints. check out the example here
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 12:26am

Hi Vipin,

According to your description, you want to load only those file which contains %vendor% in Foreach Loop Container.

To achieve your requirement, we can specify *%vendor%*.* as Files property in the Collection tab. The following screenshot is for your reference:

Thanks,
Katherine Xiong

August 26th, 2015 2:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics