December 12, 2009 at 2:53 pm
I have an SSIS package which imports or loads data from a flat TEXT file to a SQL 2008 table. But when I try to run the package, am getting the following 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: "Unspecified error".
The weird part is it loads about 6000 rows and fails. Most of the blogs I’ve read state that the error code relates to permission but it does not make sense why it would load a portion of the file and then fail. I had the package to use the SQL Server Destination first and have also tried using the OLE DB Destination and they both fail.
Please help.
December 14, 2009 at 6:40 am
Have you read the articles, here[/url] and here[/url], and tried implementing some of the suggestions there?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply