Search
Active

1
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Type: Bug
ID: 507838
Opened: 11/3/2009 4:35:35 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Randomly throwing error and SSIS package failing fatally with below error message (while ETLing data from Source SQL Server to Destination SQL server having similar table schema on either side on datetime or smalldatetime columns).

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid date format". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid date format".
Details (expand)
Product Language
English

Version

SQL Server 2008 SP1

Category

Integration Services (DTS)

Operating System

Windows Server 2008
Operating System Language
US English
Steps to Reproduce
Randomly occuring while ETLing data from source SQL Server table to Destination SQL Server with similar data type (Datetime, SmallDatetime).
Actual Results
Fatally terminating the ssis package with error..
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid date format". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid date format".
Expected Results
SSIS package should run successfully without error.
Platform
X64
File Attachments
0 attachments
Sign in to post a comment.
© 2009 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement