Professional Web Applications Themes

execute DTS package - Microsoft SQL / MS SQL Server

dtsrun is a command line utitlity which runs the DTS package. you can call this utitlity using xp_cmdshell inside a stored procedure. you can get more help on DTSRUN in BOL. -Vishal "Salim Afar" <safsarluckyeye.com> wrote in message news:OVrJ7DyPDHA.704tk2msftngp13.phx.gbl... > Hi, > How can I run a DTS Package with T-Sql? > I need to run it with a Stored Procedure. > Thanks, > Salim > >...

  1. #1

    Default Re: execute DTS package

    dtsrun is a command line utitlity which runs the DTS package. you can call
    this utitlity using xp_cmdshell inside a stored procedure. you can get more
    help on DTSRUN in BOL.

    -Vishal

    "Salim Afar" <safsarluckyeye.com> wrote in message
    news:OVrJ7DyPDHA.704tk2msftngp13.phx.gbl...
    > Hi,
    > How can I run a DTS Package with T-Sql?
    > I need to run it with a Stored Procedure.
    > Thanks,
    > Salim
    >
    >

    Vishal Parkar Guest

  2. #2

    Default Re: execute DTS package

    One method is by using DTSrun utility and the xp_cmdshell stored procedure.
    You can look at the specifics of the DTSrun utility in the BOL.

    --Drew

    "Salim Afar" <safsarluckyeye.com> wrote in message
    news:OVrJ7DyPDHA.704tk2msftngp13.phx.gbl...
    > Hi,
    > How can I run a DTS Package with T-Sql?
    > I need to run it with a Stored Procedure.
    > Thanks,
    > Salim
    >
    >

    Drew Seale Guest

  3. #3

    Default execute DTS package

    Hi,
    How can I run a DTS Package with T-Sql?
    I need to run it with a Stored Procedure.
    Thanks,
    Salim


    Salim Afar Guest

  4. #4

    Default Re: execute DTS package

    Salim,

    You can call the dtsrun utility using master..xp_cmdshell or write sp_oa*
    calls to do the same.Details here
    [url]http://www.sqldts.com/default.aspx?6,104,210,0,1[/url]
    Another option would be to include the dts package inside a sql job and then
    call the job using sp_start_job inside the stored proc, the downside is that
    you cannot have two instances of the same job running at the same time.

    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    "Salim Afar" <safsarluckyeye.com> wrote in message
    news:OVrJ7DyPDHA.704tk2msftngp13.phx.gbl...
    > Hi,
    > How can I run a DTS Package with T-Sql?
    > I need to run it with a Stored Procedure.
    > Thanks,
    > Salim
    >
    >

    Dinesh.T.K Guest

Similar Threads

  1. Question Execute SQL satatements in perl using DBI execute method
    By bennjoe in forum Brainstorming Area
    Replies: 0
    Last Post: October 7th, 04:53 PM
  2. MX7 can't execute MAX()
    By rayspeed in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 12th, 04:51 PM
  3. Cannot execute DTS package
    By Peter Afonin in forum ASP.NET Security
    Replies: 3
    Last Post: September 14th, 09:31 PM
  4. cannot execute?
    By Martin Hudec in forum PHP Development
    Replies: 0
    Last Post: September 25th, 01:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139