Post reply

Unable execute DTS from SQL exec

  • December 15, 2006 at 7:52 am

    #171232

    I am able to execute the DTS directly from the enterprise manager DTS tool but unable to execute the sql EXECUTE ExecuteDTS @@SERVERNAME,'DTSProject'

    Thank you.

    -W R

  • December 15, 2006 at 9:38 am

    #678386

    I have to admit I've never heard of executing a DTS package this way.  I thought that SQLExecute was only for SQL statements.  Have you been able to run DTS packages like this before?  Or, is 'ExecuteDTS' a homegrown tool?

    Greg

    Greg

  • December 15, 2006 at 9:46 am

    #678388

    I have come to know it is a homegrown tool.

    -W R

  • December 15, 2006 at 10:08 am

    #678398

    Sorry, I can't be much help then.  Unless you can figure out what ExecuteDTS is doing.  Maybe it's a stored procedure that uses DTSRun?

    Greg

    Greg

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

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