Hi, I've a source data like eno ename 1 ravi 2 rakesh 3 yamini like this .I want flat file output like eno=1,ename= ravi eno=2,ename=rakesh eno=3,ename=yamini like this can any one help to me to solve this problem

Set up a Derived Column transform, and specify two new columnsm as follows: "eno = " + (DT_STR 8, 1252)[eno] "ename = " + [ename] These both concatenate literal strings with the field values. The top needs to convert the [eno] field to a string before it can be used.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

BUT the output is not a oledb ,destination is flat file

OK, so from the Derived Column transform, send it to a Flat File Destination Adapter (in the Toolbox alongside other Destination adapters) and configure it accordingly.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.