I created a Package in the Business Intelligence studio to Import data from Excel file into SQL Server 2005 using a Excel Source and a OLE DB Destination that uses a data convertion transformation before it reaches the destination a mjority of
the data is copied over. However i am having 2 Issues.
1. In the Date field some of the values appear as Null in SQL Server
2. I need to change the format of the date in Excel from dd/mm/yyyy to mm/dd/yyyy before inserting into SQL Server if Possible.
I am not sure of the solution for Ques 1 but i attempted using a script task for #2 It did not work. Please Advice what the best way to proceed Thanks.
View Complete Post