Hi All, Can somone help me with some suggestion. Requirement here is to export the value in an excel sheet to a position delimited flat file. Column header can be ignored. Each column in the output should start at a predefined position and end at predefined position for ex. column1 in the excel sheet should start at position 1 and end at postion 50 in the output file. Thanks.

Excel Source to Flat File Destination. Flat file destination should be set to fixed width. Excel Source can be set to ignore column headers. User ruler to mark your destination columns.

Thanks for your reply. On trying with Flat file destination with fixed width. Output is coming in a single line. ex. Row1 Row2 Rows3NextRow1 NextRow2 NextRow3... Is there a way to add a carriage return. Pls let me know. Thanks.

Hi All, I am in urgent need of some help. Can someone please help with the control flow and Data flow tasks to export the value in excel sheet to a position delimited text file. Thanks.

There is a property on the first page of the connection manager called "Header Row Delimiter" that allows you to set a CR/LF or other character(s) as the row delimiter. Talk to me now on