InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 18:13:50 GMT20http://www.sqlservercentral.com/Forums/Topic574811-148-1.aspxWould 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=955706In addition,on the Script Task check for the PreCompile to be False if you are on Service Pack 1 or something.Tue, 29 Dec 2009 08:36:12 GMTsaranghttp://www.sqlservercentral.com/Forums/Topic574811-148-1.aspxI 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,MonishaTue, 23 Sep 2008 15:45:43 GMTM Shah