Post reply

Quickest way to run a DTS package from a stored procedure??

  • September 19, 2007 at 3:52 am

    #118274

    Hi All,

    I have a DTS package all set up which takes about 2 secs to run when running it directly through enterprise manager.

    However when I use xp_cmdshell it takes nearly a minute.

    I need to increase performance - how can I do this?

  • September 19, 2007 at 10:35 am

    #734653

    I have no idea if it will improve your performance, but there are two main options that I know of if you want the call written in T-SQL without using xp_cmdshell. You can either go the OLE Automation route, documented in many places, including here, or you can create a job that runs the DTS package and use sp_start_job.

  • September 19, 2007 at 6:50 pm

    #734771

    Just curious... What does the DTS package do?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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