I'm writing a very basic SSIS job using VS2005, SQL2005 SP2 The job consists of 2 control flow items an XML Transfer which works fine, and an Execute SQL Task which performs the following: Update DVD.LibrarySet Title = CASE When Title like 'The %' THEN (SUBSTRING(Title, 5, 255) + ', The') When Title like 'An %' THEN (SUBSTRING(Title, 4, 255) + ', An') When Title like 'A %' THEN (SUBSTRING(Title, 3, 255) + ', A') Else Title END; The error is: [Execute SQL Task] Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Mike The book from which I've taken the sample says nothing about setting the Resultset, connection or parameters properties. Any guidance would be appreciated. Mike

Mike - You mentioned that "The book from which I've taken the sample says nothing about setting the Resultset, connection or parameters properties." If you open up the "Execute SQL task", what do you have the "Connection" property set to? If there isn't a connection set up, you can select "New" and create a new conncetion to define which database to execute this task against.

Matt: Sorry I was mistaken there is a connection in the properties of the SQL Task, which is Adventure Works the same as in the Connection Manager and the SQL Server Destination in the Data Flow. Result Set is currently set to none, but I've tried the other setting with similiar results. Here is something else. When I edit the SQL Server Destination of the Data Flow and hit the Preview button on the Sql Destination Editor I get: TITLE: Microsoft Visual Studio------------------------------ Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154. ------------------------------BUTTONS: OK------------------------------ Which is odd since when I execute the job the Data Flow for the XML Transfer completes successfully. Mike

Mike - I found someone else who was getting the same error and resolved it by registering SQLTaskConnections.dll using RegSvr32. Here's the link. Hope it helps! Matt

Thank you Matt. I will give that a try on Monday, and let the thread know whether it worked or not. Mike

Thanks Matt, that worked. Mike

Thanks a lot !! That helped me too.Anna

Hey matt, Worked fine. Thanks a lot!!

Thank You. This worked!!!

Worked for me too, thanks.

hi Matt, the link doesn't work... do you have other page?

hi Matt, the link doesn't work... do you have other page? Hi Matt. I would also like to see this ....... do you have an other link?