Error With Basic SSIS Job

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.Library
Set 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