wrong format from excel to ssis

Question

hello , please i have a column age in an excel file with standard format but i display in ssis using source excel it convert it to date like this example any idea how to fix it by having a number column not a date
thank you

Answer 1

MS Excel has no notion of data types. It is an electronic paper that allows any scribble. Everything is a text. That's why strongly typed environment like SSIS needs to guess what is ingested from MS Excel. And that guess is not always correct.

Your solution would be to add a Data Conversion Transformation between source and destination in the Data Flow Task.

Answer 2

which conversion i should use ??

Answer 3

Hi @asma gh ,

Please drag Data Conversion Transformation in Data Flow Task.

Hope the following link and pictures will be helpful:

SSIS Data Conversion

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?

Answer 4

excel get it as a date but i want to keep the format like it is example "595416:00:00" because i m going to treat them after that as rejected line