November 4, 2010 at 2:31 am
Hy!
I got an access-DB and i tried to push the whole data threw an SSIS-Package to a SQL-Server.
There a few DT_DATE-Columns in my Access-DB, so i tried the data conversation from SSIS.
Every datatype works fine, except the DT_DATE Values.
When i run the SSIS-Package there's always an error
Error at Data Flow Task [SQL Server Destination [532]]: The column "ABFDocDatum" can't be inserted because the conversion between types DT_DATE and DT_DBTIMESTAMP is not supported.
The datatype in the SQL-Server is a "datetime". 2010-11-04 00:00:00.000 ==> yyyy-mm-dd
The DT_DATE in the Access-DB looks like "04.11.2010" => dd.mm.yyyy
(It's also possible to change the datatype in the SQL-Server.)
How can i change this problem?
I just need these date-Values in the sql-server.
It's my first SSIS-Package and i cant find any solution for me.
Thank you for your expertise help.
_______________________
Christoph
November 4, 2010 at 7:40 am
SOLUTION:
Change the Output Columns @ OLE DB Source
1. Right Click on OLE DB Source --> Show Advanced Editor
2. Go to Tab "Input and Output Properties
3. OLE DB Source Output --> Output Columns
4. Go to the Field with the datatype "date"
5. Change the Data Type Properties --> DataType to ==> database timestamp [DT_DBTIMESTAMP]
Hope it will help the next searching guy!
greetings from austria
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply