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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy