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?