Missing data from excel

I have a data in excel sheet which is to be loaded to sql table. The Column called seq_num has data with leading 0's these 0's are ignored while loading through ssis.

Example if seq_num is like 0099988 the sql table would get 99988, how to get the whole data with missing anything.

FYI: seq_num on excel source has a data type as dt_r8.

August 24th, 2015 4:07pm

Hi sree,

Change the data type on the Input column seq_num (the source) to be of type DT_WSTR (needs to be textual).

Should be able to do that in the Advanced Editor, and make sure the data type remains the same in the upstream.

Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 4:31pm

It didn't work.
August 24th, 2015 4:52pm

I guess you did this:

So then delete the Excel Source and re-do it.

Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 5:11pm

Change the data type of that column to text in excel
August 24th, 2015 5:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics