I have a flat file i need to import into SQL. For a lot of boring reasons, I curently don't have access to use BIDS, only the import wizard in SSMS. The flat file looks sort of like:
A 2 B G -blank line here- 8 R F 6
Basically, a few lines, separated by an empty line, Repeat a few thousand times. The text field here doesn't show it all that well, if you have questions about that, I can try to clarify.
What i need is for each of those groups to be its own row, merged together with a delimiter. So, the data in the table would look like:
Only one column in the table, with a delimited string of data in that column.
Can this be accomplished via the wizard? If not, can it be accomplished with BIDS and a real SSIS package? That may be an option, but it will probably be a while before I have access to that, and by that time, it may be moot.