locked
SQL server import and export wizard RRS feed

  • Question

  • I am using SQL Server 2012 Version  11.0.2100.60

    Whether I try to import data into a database or export I receive the following error: 

    SSIS Runtime Object could not be created.  Verify the DTS.dll is available and registered.   The wizard can not continue and will terminate.

    Additional imformation :

    Creating an instance of the COM component with CLSID {8BF6572D-674B-494E-9047-DDD0E24BB785} from the IClassFactory failed due to the following error : c0010014Execption from HRESULT : 0xC0010014 . (DTSWizard)

    I have no idea why I am getting this error and would appreciate any help. please tell me what i have to do step by step

    Thursday, March 5, 2015 4:14 PM

Answers

  • Make sure you can locate DTS.dll And then just register this DLL e.g. in Command Prompt: regsvr32 C:\path\DTS.dll

    Arthur

    MyBlog


    Twitter

    Thursday, March 5, 2015 4:20 PM