Please help. I have an Excel file that I am importing into SQL Server via SSIS and I have a cell that is date formatted.
My problem is that in the spreadsheet the value is 01/07/2011, meaning 1st July 2011. However when I import using SSIS in my dataflowtask using the data conversion component to save the type as a DT_DATE, the record in the database is showing as 2011-01-07
00:00:00:000, meaning 7th January 2011. How can I use SSIS to format the data that is inserted into SQL Server as DD/MM/YYYY so I get 1st July 2011?
Any suggestions most welcome. Thanks in advance.
View Complete Post