Jeff Moden (5/13/2013)
Brandie Tarvin (5/13/2013)
Duh. Forgot there is a record 4 line which is the last line of the file. Anyway, sample data attached and CREATE TABLE code as follows:Heh... ok. I've watched this long enough and now they're starting to use really nasty 4 letter words... like SSIS.:-D
How many lines of data does your typical file have? And, any limits on the type of SQL Server objects that you can create?
LOL, there is nothing wrong with SSIS, particularly to solve an iterative programming artifact that breaks normalization rules because it was originally built to be processed by iterative programs. 😛
Not my magic, though, Magoo. I learned off others just like everyone else. 😉 I did however trip over a link that I think embodies the process in the most simplified method possible; it's just the facts, ma'am:
http://agilebi.com/jwelch/2007/07/12/processing-a-flat-file-with-header-and-detail-rows/
(As to the SSIS, what did you expect me to solve this with... SQLCLR? :hehe: )
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