Monday, 24 May 2010

SQL 2008 DTSWizard error

I have just fixed an annoying problem with regards SQL server 2008 Express. I installed the management tools and the DTS Wizard failed to work with the following message:

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.

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.