Export to a fixed length "flat-file" using SSIS -
10-25-2006
, 03:49 PM
I have to export to a fixed length file which has the following
structure
A1234 RT XXX XXX
BXXXXXXXXXXXXXXRT JJ
C JJJ IUD
A1234 RT XXX YYY
BXXXXXXXXXXXXXXUU OO
C JJJ ABC
....
....
If you look at the structure you can see that each row ( the first 3 )
have a different layout. This pattern repeats after the 3rd row. I was
wondering if I could use SSIS to create this file.
Thanks,
Pete |