Post reply

DTS Designer error

  • February 20, 2011 at 9:28 am

    #157451

    Hi,

    Whenever i opend the package in sql server 2000 standared edition sp4

    getting error " The specified module could not be found "

    Please help me

    Thanks

    Jernas

  • February 21, 2011 at 2:30 am

    #1289324

    This usually means either one of the data provider modules (Oracle etc.) was not found or one of the task modules was not found. One thing that really catches people out with DTS is that it always runs (and edits) on the client you are on - not on the server - so you can have things that run fine on the server but fail when opened on the client because some dependency is installed on the server but not on the client. Try remote consoling to the SQL server the job runs on and see if you can open the job without error there. Actually the DTS designer is so rubbish and sow when remotely editing jobs you may find it better to edit jobs via remote console anyway.

    James Horsley
    Workflow Consulting Limited

  • February 21, 2011 at 2:42 am

    #1289329

    thanks,

    How to resolve this issue in main production server..

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

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