SQLTeam.com | Weblogs | Forums

Import non-tabular reports


Is there a way, within SSIS, to specify field positions within a non-tabular report? I can use Monarch to accomplish this, then import the result, but I was hoping for an automated process.

So take the example report below, ID would be at position 1 and 4 characters long, Desc is at position 15 and can be 35 characters long, and so on.

ID Desc Count
23 Test 1 7
345 Test 2 53
3244 Test 3 235

To further compound it, I have files with several different formats. Is there a way to handle this, or would I need to use another application to parse the report out and load the tabular data?


IIUC you could use a File destination in the dataflow with fixed column widths