datatype conversion error in SSIS package

Posted on 2011-10-21
Medium Priority
Last Modified: 2012-08-13
I have a SSIS Package which fails to transfer data to the destination  database table.
The error I am getting is;
[SQL Server Destination [3131]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E07  Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime.".

The datatype in some of the database table columns is datetime and I have converted  some columns of the source data to DBTYPE_DBTIMESTAMP, which I assume is compatible with datetime…

Any help appreciated, thanks
Question by:blossompark
LVL 11

Accepted Solution

Simone B earned 1500 total points
ID: 37006317
According to books online, that should work. http://msdn.microsoft.com/en-us/library/ms175970.aspx

Also, it's not your data conversion task that is failing, it's the insert into the destination. Chances are very good that you have specific values that are failing. You may have to examine your source data to find the values causing the problem.

Author Closing Comment

ID: 37029903
Hi Buttercup1,
     sorry about  the delay in responding to you....thanks for the link....i have created a derived column which seems to have got around this issue,,,,thanks again for the article link

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question