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?
--Jeff Moden
Change is inevitable... Change for the better is not.