Post reply

Best way to execute a DTS package via OSQL

  • February 22, 2005 at 8:17 am

    #92454

    What is the best method to execute a DTS package via OSQL?

  • February 22, 2005 at 8:32 am

    #543483

    You can use the dtsrun utility directly from the command prompt

  • February 22, 2005 at 8:34 am

    #543484

    can it be run from a machine that doesn't have sql installed though?

  • February 22, 2005 at 3:17 pm

    #543571

    You will need to have the appropriate DLL's etc... in order to run DTS. From memory, I think that there is a list over a http://www.sqldts.com

    Bear in mind that DTS is a client application and will execute on the machine it's started from. This means that if you start a DTS package on a third machine that performs a datapump between two other SQL Servers then the data will actually flow through that third machine.

     

    --------------------
    Colt 45 - the original point and click interface

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

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