Hi All,

My source data in OLEDB Source and Destination is CSV.

Below is the sample data

claim	claim_number
123	000123
124	000124
125	0000125

But while loading OLEDB source data into CSV in Claim_Number column not considering the leading zeros and getting output as below.

claim	claim_number
123	123
124	124
125	125

is it possible to handle with script to get the leading zeros ????

Perhaps you can use Conversion task to CAST it as INT?

Hi harikiran,

if your not really worried about data type in csv (retain same datatype as in table) then you can have a derived column and have the expression adding leading single quotation mark ('). I think that way when you load into csv it will have leading zeros. But that column in csv will no longer be NUMERIC. It will be TEXT.

Hi All,

My source data in OLEDB Source and Destination is CSV.

Below is the sample data

claim	claim_number
123	000123
124	000124
125	0000125

But while loading OLEDB source data into CSV in Claim_Number column not considering the leading zeros and getting output as below.

claim	claim_number
123	123
124	124
125	125

is it possible to handle with script to get the leading zeros ????

Be sure that your claim_number column is configured to be a string when importing or exporting to save those leading zeros.

Same goes for importing:

EXPORT RESULTS:

id,claim_number
123,000123
124,000124
125,0000125

I hope that helps!

It could be an issue with your csv file.

Check the tata type of your csv file column.

• Proposed as answer by Katherine XiongMicrosoft contingent staff, Moderator 4 hours 38 minutes ago