This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
I am importing dates from excel to SSIS to load data but some values are null in dates so ssis unable to read it as date and reading as nchar
SSIS reading as number or nchar
have another date dimension where there is no null data and reading properly
expected results as below.Please suggest . I heard about ime=1 but do not know how to import it
the value in source is 
and target datatype is integer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Please use the Comment button to respond to answers instead of creating new answers each time. It is hard to tell who you are responding to and what the context is.
What is your question here?
Hi @Shambhu Rai ,
Right click on your flat file source and select the Show Advanced Editor.
In the Input and Output Properties, expand Output Columns, find your column and change the FastParseproperty from False to True.
If it still thrown error, try to redirect the error rows to output and then check the value to find the error cause.
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.