Post reply

DTS ERROR

  • October 11, 2010 at 1:22 am

    #239653

    Hi All,

    Below is the error that we are receiving while executing the sql server agent job from sql server 2008 which will run DTS package.

    “Executed as user: AU\svcsql_dev. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

    DTSRun OnError: DTSStep_DTSActiveScriptTask_1<c/> Error = -2147220487 (800403F9)

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

    Error source: Microsoft Data Transformation Services (DTS) Package”

    The above error we are getting only for the dts packages having Activex scripts.

    if anybody knows the solution of this issue.. kindly let me know,,

    Thanks

    Balaji.G

  • October 11, 2010 at 4:50 am

    #1234887

    Have you tried registering the Activex Script Host?

    Instructions here: http://www.sqldts.com/224.aspx

  • October 11, 2010 at 5:56 am

    #1234922

    Cath Trimble (10/11/2010)

    Have you tried registering the Activex Script Host?

    Instructions here: http://www.sqldts.com/224.aspx%5B/quote%5D

    Hi Cath,

    I had registered the following dll file into my client machine.. but the

    problem still continue

    Regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll"

    In that dts packages are running at client machine.. but objects are

    available at prod server only..

    My question is.. shall i register this dll file to my client machine or prod server

    if Client machine only means, then what is the alternate solution for this?

    Thanks a lot for your reply

    Regards

    Balaji.G

  • October 12, 2010 at 2:42 am

    #1235349

    Hi Balaji.

    Did you try registering dtspkg.dll and dtspump.dll on your client machine too? Also, this is the 2008 forum - are these packages migrated from 2000? There are various issues with migrated packages and Activex: http://msdn.microsoft.com/en-us/library/ms143462(v=SQL.100).aspx The Activex Script Task is deprecated in 2008, BOL recommends using the Script Task instead: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10is_1devconc/html/2fade433-40d8-4ca8-8c9a-210605a1bc87.htm

    Hope that helps.

  • December 12, 2010 at 10:58 pm

    #1261524

    Hi Balaji,

    As part of server cleanup after SQL SERVER 2008 upgrade, I uninstalled SQL Server 2005 along with shared components yesterday as I had Installed SQL Server 2008 SP1 on the server a couple of months back. And now I am facing the same problem as you mentioned above. The job using the DTS package that has an ACTIVE X script fails while other DTS jobs finish nicely. I am wondering if you had found any solution yet. If you have, it will be much appreciated if you can share.

    Regards,

    Ali

Viewing 5 posts - 1 through 4 (of 4 total)

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