[OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "PrevNonMonDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_I8" and "DT_DBTIMESTAMP" for "DelinqDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "PrevNonMonDate".

There is a chance you misconfigured the target fields, but if not, the remedy is in placing a Data Conversion Transformation to make it the proper datatype. Oftentimes though one will need a Derived Column Transformation instead this because the input values do not look like a time stamp and I trust this is your case.Arthur My Blog

I used conversion to change the datatypes, and the errors i got are mostly bigint to datetype conversion and numeric to datetype conversions. i used the following case to convert my datatype before. case WHEN LEN(LTRIM(RTrIM(OPENDATE))) = 5 then CAST(CAST(('20' + '0' +LTRIM(RTrIM(OPENDATE))) AS VARCHAR(8)) AS DATETIME) when LEN(LTRIM(RTrIM(OPENDATE))) = 6 then CAST(CAST(('20' +LTRIM(RTrIM(OPENDATE))) AS VARCHAR(8)) AS DATETIME) end AS OPENDATE,

It only matters what is the end result of the SQL expression, post it hereArthur My Blog

these are the conversions im doing in a table using SSIS, i used data conversion to insert the changed values into the destination [LastNonMon] [decimal](19, 4) NULL - [PrevNonMonDate] [datetime] NULL, [ExpDate] [decimal](18, 0) NULL - [ExpirationDate] [datetime] NULL, [DateLastPlastic] [decimal](18, 0) NULL - [PrevPlasticDate] [datetime] NULL, [DateLastPinMailer] [decimal](18, 0) NULL - [PrevPinMailerDate] [datetime] NULL, [StartDateDelinq] [bigint] NULL - [DelinqDate] [datetime] NULL, [PaymentDueDate] [bigint] NULL - [DueDate] [datetime] NULL. ERRORS during the exection of my package [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "PrevNonMonDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "ExpirationDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "PrevPlasticDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBTIMESTAMP" for "PrevPinMailerDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_I8" and "DT_DBTIMESTAMP" for "DelinqDate". [OLE DB Destination [6556]] Error: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_I8" and "DT_DBTIMESTAMP" for "DueDate".

Hi Sreez.Learner, DT_NUMERIC data type cannot be convert to DT_DBTIMESTAMP, DT_I8 cannot be convert to DT_DBTIMESTAMP also, I suggest you conevert DT_I8 to DT_NUMERIC, and then convert all the DT_NUMERIC to DT_Date, at last convert them to DT_DBTIMESTAMP data type. For more information about SSIS Casting, please refer to: http://msdn.microsoft.com/en-us/library/ms141704.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Hi Sreez.Learner, DT_NUMERIC data type cannot be convert to DT_DBTIMESTAMP, DT_I8 cannot be convert to DT_DBTIMESTAMP also, I suggest you conevert DT_I8 to DT_NUMERIC, and then convert all the DT_NUMERIC to DT_Date, at last convert them to DT_DBTIMESTAMP data type. For more information about SSIS Casting, please refer to: http://msdn.microsoft.com/en-us/library/ms141704.aspx Please feel free to ask if you have any question. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.