Layout File for a Fixed-Length Flat File

Hi,

Does the flat file connection format (Fixed Width) have anyway to include a file layout to define the columns. We have different files which contain over a hundred columns.

Or is there any other way to do this. Script Component?

Thanks,

ShantiThe one option is to have a template package and copy the flat file connection from that package to your new package|||If I understand the question, you want to have something like a format file that the flat file connection manager UI can read to create the files.

We don't have a way to do that though we wanted to get it in. If you have hundreds of columns, I suggest writing a quick program that creates such a flat file connection manager using the runtime object model. There's a sample installed that helps you create a package, connection managers, data flow, etc. which might be a good place to start.

regards,
ash|||Yep, Ash you understood correctly. Thanks for the feedback.