Data Import - Flat File to SQL 2005 table 1

[teblack]

I have a SSIS package that reads in a file. There is a conditional split near the bottom of the package. For each record there is a determination about what code to store that record under. i.e. "C" - Current, "F" - Former, "N" - Never. Currently the cond split will load the record into one and only one type. But, is there a way to allow one record to be loaded with multiple types. One record could have all three types or just one. I have read about using concat on the conditional splits, but have been unable to find any examples.

Thanks in advance for any help with this..



TBlack -

 

[MDXer]

One way would be to insert a multicast prior to the conditional split. Send one output to your current condiditonal split. Send a second output to a second conditional split. In this conditional split filter out all the records that would allow the mutiple codes to be applied.

However if you are using the conditional split to simply apply a code you may be better served in using a derived column Transform and doing something like

[ColumnA] = "N" ? [ColumnA] : "Never"
[ColumnA] = "F" ? [ColumnA] : "Former"
[ColumnA] = "C" ? [ColumnA] : "Current"

etc...

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