File Handling in SSIS

[Gadall]

We currently receive files from a client that are automatically copied to a folder on the server. There are two types of files, 1) Gets imported into the table 2) Gets imported into a temporary table and the main table is updated from this.

Where I'm having the issue is that I can tell the files apart by the fact that the "update" file will always have the string "limitedBasic" in the file name, I don't know how to look for this in the SSIS package that does the file processing. Currently it grabs all .xls files. I have the code for handling each file type, but am stuck in how to look at the filename and then call the relevant code for each.

 

[Viass]

You could try two 'For Each Loop Container' each handling
a different file type and its relevant piece of code.

 

[MDXer]

int the For Each Loop proerty it asks for a file name you should be able to do something like C:\MyFolder\*limitedBasic*.xls

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck