September 26, 2011 at 2:12 pm
I created a simple SSIS package a while ago that creates a table (TableA) on Database2, then copies the data from Database1.TableA to Database2.TableA
Very basic, but now I want a similar package copying the TableA from Database3 to Database4. I save the existing page with a new name, modified the connection, everything looked right, but I get an error:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.5000.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 4:09:51 PM
Error: 2011-09-26 16:09:52.71
Code: 0xC0202009
Source: Database3_DialLeadsTemp_Transfer Connection manager "DestinationConnectionOLEDB"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error
Error: 2011-09-26 16:09:52.71
Code: 0xC00291EC
Source: Preparation SQL Task Execute SQL Task
Description: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
I saved the new package as Database3_DialLeadsTemp_Transfer Connection.
What does "Class not registered" mean ?
I have full permissions to all the databases. I can't see anything wrong.
What am I missing ?
September 26, 2011 at 4:11 pm
Open the package in BIDS, rename it to something else, when it asks to rename the package object tell it yes. Rename it to what you really want it to be and tell it yes again. I'm 99% sure that will fix the problem..
CEWII
September 27, 2011 at 8:12 am
Thanks, I'll try that next time. I already gave up and created a new one from scratch.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply