Hi Ed,

Thanks for your response. Client is insisting me to export the data in .csv only.

It works when I export the data using .txt with delimiter but this client requirement...

Thanks Phil. Appreciate for your fast respsone.

I opened the file in text editor and able to see leading zeros and when I tried to open the same .csv file in excel leading zeros are missing.

I  am...

Thanks Phil for your quick response and I attached the file which has steps.

I am using DT_STR with length (9) from beginning till last step of the process.

Step 1: OLEDB Source

Select RIGHT(REPLICATE('0', 9) + CAST(SSN AS VARCHAR(9)), 9) AS SSN

From dbo.XYZ

Step: 2 Flat...