We help IT Professionals succeed at work.

Export error in SQL Server 2005

Eileen Murphy
Eileen Murphy asked
on
When I try to export a database this is the error I get...
------------------------------
TITLE: SQL Server Import and Export Wizard
------------------------------

The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate.

------------------------------
ADDITIONAL INFORMATION:

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error:  could not be found. (Exception from HRESULT: 0x80030002 (STG_E_FILENOTFOUND)). (Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------
I ran a repair and it didn't fix the problem.

I tried to register the DTS.dll and got this error message:

The module "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dts.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005.
Comment
Watch Question

View Solution Only

Commented:
Hi,

Looks like User Access Control is set ON. Can you set it OFF and try registering?
Eileen MurphyIndependent Application Developer

Author

Commented:
Can you please tell me where that is set?
Eileen MurphyIndependent Application Developer

Author

Commented:
Sameer  - that was it! Thank you for your help!