Post reply

DTS package is failing after the uninstall of SQL Server 2005 components

  • July 2, 2010 at 6:14 pm

    #387269

    Hi,

    We have 2 node a/p cluster setup for SQL Server 2005 x64 with SP3 and have a DTS package running fine.

    Performed the in-place upgrade to SQL Server 2008 on passive & active nodes and also applied SP1. Everything went well.

    Installed Microsoft SQL Server 2005 Backward Compatibility Components, and then the DTS package was running fine with nO issues.

    After a week, Uninstalled the SQL Server 2005 components, Client components, Management tools and SSIS EXCEPT Microsoft SQL Server 2005 Backward Compatibility Components and from then the DTS package is failing with with the below error:

    DTSRun: Loading...

    DTSRun: Executing...

    DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

    DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9)

    Error string: ActiveX Scripting was not able to initialize the script execution engine.

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts80.hlp

    Help context: 4500

    Error Detail Records:

    Error: -2147220487 (800403F9); Provider Error: 0 (0)

    Error string: ActiveX Scripting was not able to initialize the script execution engine.

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts80.hlp

    Help context: 4500

    DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1

    DTSRun: Package execution complete.

    Please advice me what needs to be done to make DTS work in SQL Server 2008?

    Do we need to keep all SQL Server 2005 components even after the in-place upgrade to SQL Server 2008 to work DTS?

    Thanks

  • July 3, 2010 at 4:17 pm

    #1188574

    Read this:

    http://msdn.microsoft.com/en-us/library/bb500440.aspx

    And learn how to google 😀

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply