Post reply

error executing DTS package

  • June 12, 2006 at 3:00 am

    #67449

    Hi,

    i'm trying to execute this DTS package and the following exception is thrown,

    "activeX scripting encountered a run time error during the execution of the script" . What could be the reason for this exception, plz hlp.

     

  • June 13, 2006 at 6:39 am

    #643346

    Can you tell us a bit more about your package?  Is it just a simple copy column transaction or are you doing more with the package?  Are you getting any error codes?  Does this only occur when it's scheduled, or doe sit happen all the time for every user? 

    Is the part of your package that's having uses exectuing on the main package thread?  I've seen this create issues with ActiveX before.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • June 13, 2006 at 7:11 am

    #643362

    As Luke says, it depends on what you are trying to do. I recommend turning on the just in time debugger.

    On the server console pane (the left side of the screen), right click Data Transformation Services. Now select Properties from the context menu. You'll see three check boxes, one of them is to turn on JIT debugging.

    Now when a runtime error happens, the JIT will ask you if you wish to debug. You can then see which line is throwing the exception.

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

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