April 21, 2015 at 12:45 pm
I am attempting to write fixed length data to a fixed width flat file. In my Flat file destination connection manager, under the general section for the format I have selected Fixed Width and gave it the path. From there I went to the columns section and created each of my columns and made sure the length was set correctly.
From here I pulled in my flat file destination component from the tool box. Set it to use my connection manager that I set up above and made sure the columns were mapped correctly.
Everytime I run my package, I get the following error:
[FF_DEST - Write data to file [869]] Error: No column was specified to allow the component to advance through the file.
AND
[DTS.Pipeline] Error: component "FF_DEST - Write data to file" (869) failed the pre-execute phase and returned error code 0xC02020F0.
I have been googling this (with not much luck at all) and trying different things to get this to write.
In short, I followed this link to be able to create the fixed width file and I am still not having any luck:
https://ctrlshiftb.wordpress.com/2009/11/27/using-ssis-to-export-a-fixed-width-flat-file/
If anyone has a solution to this issue and could share, I would greatly appreciate it.
Thank You!!
April 23, 2015 at 3:57 am
Hi
It looks like the problem exists in incorrect width, please check InputColumnWidth property of FF, it should be
equal or greater then the source column length.
Regards
Mike
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply