Menu
Go to the Connection Manager you defined for your flat file. In the left box, select General and set the Format to "Fixed Width". Then in the left box, select Advanced and here you can set the OutputColumnWidth for each field.
Does any one have a tutorial on how to import a fixed width flat file into a database using an SSIS package?
I have a flat file containing columns with varying lengths.
Column name Width
----------- -----
First name 25
Last name 25
Id 9
Date 8
How do I convert a flat file into columns?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With