Almost done with setting up some substantial test data for this thread but I need some more information.
- Will the embedded header (the line with ID,name,sal on it) ALWAYS be immediately preceded by a NULL or blank line?
- Will Colons (:) EVER be allowed as a delimiter for the actual data rows?
- Also, which revision of SQL Server are you using? 2016? 2017? or ???
Ah... I also just noticed which forum this is posted to, so also be advised that I don't use SSIS for these types of things (heh... one of my specialties is making SSIS unnecessary for these types of things 😀 ). My solution will be a T-SQL solution. If that doesn't work for you, then someone else will need to help.
Please let me know so I don't waste either of our times.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)