April 15, 2009 at 9:49 pm
Hi All,
I have a date column in Excel sheet. if the user type a varchar or numeric data for 8 to 10 lines then type date values - in my source it is coming as NULL values. actual date values are not coming.
how to solve this.
Thanks,
Regards,
Viji
April 15, 2009 at 9:58 pm
Have you trying using the Data Conversion task in the Data Flow tab. Should be up to the task.
Fraggle
April 16, 2009 at 5:26 am
In properties on the excel connection manager.
Check the connection string. Make sure IMEX=1 in the extended properties.
i.e
Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";
hope that helps
April 16, 2009 at 8:39 pm
Hi,
Thanks a lot. setting extended properties to IMEX=1 works, provided when i set all my excel columns meta data to text.
regards
viji
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply