Hello everyone i want data to be written in flat file comming from database for this i have used 1)OLEDB Source 2)Flat File destination in OLEDB Source i have used SQL query in which i am getting result like EMPID EMPNAME EMPAGE EMPDESG 1 ALEX 21 EXE 2 FORD 20 EXE in flat file i want same result but in flat file my result header are comming in different positon given below. i m not getting how to customize the flat file to get result as above.can anyone provide me some suggestion or link for this kind of problem. EMPAGE EMPDESG EMPID EMPNAME 21 EXE 1 ALEX 20 EXE 2 FORD

Hi, Go to this link Step by step ProcessSee this Hope this will help you !!! Sanjeewan

Hi, When you create your flat file connection manager, please make sure the sequence of these columns should be : EMPID EMPNAME EMPAGE EMPDESG the same sequence of your source columns. The columns of my flat file will be : AddressLine1, AddressLine2, ModifiedDate Please vote if it's helpful and mark it as an answer!

No it doesnt resolved my problem please go trough above problem again. in this link it simply telling how to copy database data to flat file.

No it doesnt resolved my problem please go trough above problem again. in this link it simply telling how to copy database data to flat file. Which solution doesn't work ? Sanjeewan's or mine ? Could you please show you column sequence in flat file connection manager editor as my screenshot shows ? Please vote if it's helpful and mark it as an answer!

Sanjeewan Kumar Solution. I m working out solution you have given to me

Hi, How are you getting the columns in the OLEDB Source? Is it SELECT * FROM, or are you specifying the columns as per your output in the SELECT? If you are getting the data in the OLEDB source in the sorder you want it in the output, delete the destination flat file connection. Recreate the connection from the Flat File Destination, it will take the order as the input buffer and your issue will beresolved. Else create a delimited file with the headers you need in the order you need and create a file connection to this. Modify the data types as per your need and then use this flat file connection in yout flat ile destiantion.My Blog | Ask Me | SSIS Basics