I have a flat file with 320k rows. Each row contains generic data such as a supplier number, plant name, and dock code. Each row also contains 5 sets of 4 fields route name, region code, arrival date and departure date. Each of the 4 fields
begin SX_ where the X is the set number. So for example the column names per row are:
SUPPLIER_ID, PLANT_ID, DOCK_ID, S1_ROUTE, S1_REGION, S1_ARRIVAL, S1_DEPARTURE, S2_ROUTE, S2_REGION, ...
What I need to do, using the flat file as a source, is to read the generic fields into one dataset and the SX fields into another. I then need to copy these datasets to an OLE DB destination into their respective tables. This is very easy using
a Windows Service and VB.NET. Anyone have any ideas how to accomplish this using SSIS 2008?
View Complete Post