SSIS Import Flat Files with Headers

Well today I did something new 😉

First a little background information.
The project is called ‘DLT Containment’, here’s a short quote from the PID:
DLT stands for Die Level Traceability – this system contains all genealogy for our LED’s from EPI Reactor run through the LED location in the end-product we ship to a customer (full traceability).

I made a SSIS package that processes the logging files…BUT…they contain headers (see below).
It’s actually based upon the T-SQL code from my previous post.

First I’ll show the Destination table design:

Nothing that difficult:
FST_Lot_ID = (believe it or not) WO NO
FST_SubLot_ID = LOT NO
FST_Date – Current datetime (smalldatetime..Grrrr)

I was struggling for quite a time on how I should do it.
After minutes (maybe an hour), I got an idea and worked on it.
Here’s the result of my brainstorm session:

Suggestions are welcome ofcourse.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s