Hi,
Can I hv filters for Multiple Files in the ForEach - File Enumerator of SSIS.

Basically, what I am trying to do is I am Looping thro a Directory for 2
Kinds of CSV Files one has extn '.add' n the other has extn '.upd'.

Now if I try to include filter for both of these files by specifying:
*.add,*.upd
OR
*.add;*.upd

Loop Doesnt Work !!!!

I tried to Find a lot on this but no success.
If this thing is not Supported then I will definately like to add this to
the 'Wish List' for nxt release of SSIS.

Thanks,
Sachin R. Chavan.

Hello Sachin,

I tested in my side and did reproduce this issue.

It seems that the Filter in SSIS ForEach file enumerator only could use on
wildcard file name and did not recognize the comma.

You could send the request to the product team directly.

http://connnect.microsoft.com/sql

As a workaround, you could add one more Foreach enumerator to do the job.
Hope this helps.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello ,

One way of sorting this problem would to to store the names of the files
in a variable (array) You could then enumerate the variable then in the
ForEach Loop enumerator. I know this is a long way around the problem but
you could request the file patterns from variables which you pass in through
a configuration So long as what the variable holds implements IEnumerable
then you are good.




--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.