Garbage data while intesrting data from fixed width file to sql database using SSIS

Apr 7 2011 5:30 PM

I have created a SSIS package to insert data from fixed width file to sql database.

But when I run the package on fixed width file it runs fine for some files but for other files it inserts some square garbage data into my SQL database which erases all my column formatting. here is the sample