Sample Header Ad - 728x90

VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component ", clsid {4CAC ... Could not be created

0 votes
1 answer
3181 views
I am creating my first SSIS package to support the E of our ETL from an external Oracle database to our internal SQL Server 2012 databse. Using Visual Studio 2012 and I have installed the Microsoft Oracle Connection Manager by Attunity 2.0 I had this working, then renamed and deleted some files, and tried to build it again when I ran into this problem. When running Source Assistant, I receive the Visual Studio Error: > The component could not be added to the Data Flow task. Could not initialize the component. There is a potential problem in the ProvideComponentProperties method. There is an "Additional Information" section that references: > Error at TERM [SSIS.Pipeline]: Component ", clsid {4CAC6073-BCA7-430E-BD29-68A9F0012C6D}" could not be created and returned error code 0x80070005 "Access is denied.", Make sure that the component is registered correctly. > >Error at TERM [ ]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this copmonent is "". Note: "TERM" is the name of the Data Flow task (named after the table I want to copy with SSIS. This clearly looks like registry damage to me, so I had uninstalled the Attunity copmnent and re-installed it; and I ran a repair on Visual Studio 2012 (in that order); rebooted, etc. No luck so far. Anyone ever seen this before and/or have any ideas how to get back to a working SSIS development? I am working on a development box, my Oracle Connection tests fine, and I can also connect fine to my SQL Server 2012 instance as well.
Asked by qxotk (203 rep)
Feb 28, 2014, 06:28 PM
Last activity: Feb 28, 2014, 08:42 PM