Home Forums SQL Server 2005 SQL Server 2005 Integration Services Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection RE: Unable to cast COM object of type System.__ComObject to class type System.Data.SqlClient.SqlConnection

  • 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.