Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Unable to cast COM object of type...

Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection

Rate Topic

Display Mode

Topic Options

Author

Message

M Shah

Posted Tuesday, September 23, 2008 3:45 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 18, 2010 3:56 PM
Points: 73, Visits: 51

I have a script task in the control flow where in I am connecting to the database (SQL Server 2005) and executing a SQL Statement. This was working, now when I try to change the package the script task fails with the following error:

Something Bad Happen Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.

The connection manager that I have created and I am using is a ADO .NET connection manager so that should not be the issue. Any inputs on resolving this will be much appreciated.

Thanks,

Monisha

Post #574811

sarang

Posted Tuesday, December 29, 2009 8:36 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 27, 2012 5:23 AM
Points: 11, Visits: 103

Would be worth to check what service pack you have for SQL 2005, There were a few issues with SSIS 2005 and MS came out with a bunch of hot fixes for them in their service packs,
Could be found at -
http://support.microsoft.com/?id=955706

In addition,on the Script Task check for the PreCompile to be False if you are on Service Pack 1 or something.

Post #839868

« Prev Topic | Next Topic »

Permissions