July 10, 2014 at 8:56 am
I have a text file in an odd format that was created by a custom app for tracking serial numbers.
The format is:
ordernumber, numberofserial#s, serial1, serial2, etc...
Example lines:
1234, 2, 010101010101, 010101010102
1235, 1, 010101010103
1236, 4, 010101010104, 010101010105, 010101010106, 010101010107
I need SSIS job to daily truncate table and repopulate with:
order, serial
order, serial
1234, 010101010101
1234, 010101010102
etc...
Any guidance appreciated.
Oh this is in SQL 2008 but no SSIS forum here for 2008.
Thanks!
July 10, 2014 at 12:55 pm
Asynchronous script transform (google that phrase) to transform the input properly would be my recommendation here. You have a variable set of inputs you want to control for.
The other option is delivery in full to a staging table, then use UNPIVOT and/or a UNION, followed by stripping out your NULL entries in T-SQL.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply