timmitchell.net
Ragged Flat File Processing in SSIS - Tim Mitchell
Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of which is shown below. In this small sample file, you can see that we are dealing with medical data with an inconsistent format. As shown, the rows in the pipe-delimited file can have as few as seven and as many...