Create a program to load the package and change the properties (column width) similar to that of destination columns and execute it.

Use Script component as transformation to place the logic you are looking for.

Hi,

I created a derivedcolumn component and mapped the output collection of a OLEDB source to derivedcolumn component and then mapped the derivedcolumn's output to a text file. This part...

Thank you Michael. Derived column looks appropriate.

Thank you for the reply Michael

I am very much new to SSIS. In DTS2000 I used "DTS.DataPumpTransformScript" and added VBScript using "TransformServerProperties" to map each column in input to output....

I am using VB.Net program to create the package. I want to export the table content to flat file by dynamically creating the package.

Hi,

I am also facing the same problem. Have you cracked it? If so plz let me know how.