Hi folks,

I'm looking for pointers or clues on how to handle loading different file
types into a stage table from one SSIS project. For example I may have a
table with file names and types in it and need to use the correct task for
that file type. The table may look like:

FileName FileType
na1.xls 4
na2.txt 3
na3.xls 2
na4.txt 1

Each file type has a different column layout and some basic scrubbing
differences. Once the stage file is populated I then need to scrub it some
more using the same process independant of the file type.

My current thinking is to try either lookups to control which type
processing happens or to write a script to execute the appropriate package.
(I don't know if either of those will work.)

Any suggestions, pointers, links or clues will be greatly appreciated.

Thanks
John

Hello John,

Personally I would do this


ExecuteSQL task grabs the filename + file type data and puts in a Rowset Var
ForEach loop goes over that variable

Use workflow and variables in constraints
Have a dataflow task for each variation of file

Have a look here

http://www.sqlis.com/default.aspx?306

http://www.sqlis.com/default.aspx?55



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Allan,

What a great clue! Thank you very much.

John

"Allan Mitchell" wrote: