The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate. (SQL Server Import and Export Wizard)
Cannot create a task with the name "STOCK:PipelineTask". Verify that the name is correct.
Cannot create a task with the name "STOCK:PipelineTask". Verify that the name is correct.
This PC has had SQL Express 2005 on it in the past but before installing 2008, the 2005 edition was fully uninstalled (using Add/Remove programs). The obvious answer was to follow the advice in the actual error message and register the appropriate dll but unfortunately that was answered with this:
The module "dtspipeline.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005
Now as I am on a Vista machine I established that it was a problem with permissions but running from an elevated command prompt (run as Administrator) still gave me the same message.
What cured it was typing the below into a command prompt to reset the permissions on Vista:
secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose
This was found on http://support.microsoft.com/kb/313222
Once I had run that AND then registered the dll, all seemed to work.