how to use DTS package?

Discussion in 'ASP .Net Web Controls' started by susie, Oct 28, 2003.

  1. susie

    susie Guest

    Can SQL DTS package be used in asp.net application? If it
    can be used, can anyone show me how to use it? Say my
    package name is "TranferFile"
     
    susie, Oct 28, 2003
    #1
    1. Advertising

  2. susie

    SSP Guest

    Try creating a stored procedure and then call it in an asp.net page:

    example:

    CREATE proc spTranferFile as
    exec master.dbo.xp_cmdshell "DTSRun /S SERVER NAME /U xxx /P yyy /N
    TranferFile"
    GO


    "susie" <> wrote in message
    news:01f501c39d7d$7e77f750$...
    > Can SQL DTS package be used in asp.net application? If it
    > can be used, can anyone show me how to use it? Say my
    > package name is "TranferFile"
     
    SSP, Oct 29, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. owais
    Replies:
    1
    Views:
    1,073
    Azhagan
    Oct 5, 2004
  2. Stephen Russell

    Deploy a DTS package on a Web Server C#

    Stephen Russell, Aug 13, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    728
    Ivan Demkovitch
    Aug 13, 2003
  3. Peter Afonin

    Cannot execute DTS package from ASP.Net

    Peter Afonin, Aug 29, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    617
    Peter Afonin
    Aug 29, 2003
  4. Dean R. Henderson
    Replies:
    1
    Views:
    1,524
    Natty Gur
    Nov 13, 2003
  5. bruce barker
    Replies:
    1
    Views:
    463
    =?Utf-8?B?U2lsZWVzaA==?=
    Apr 2, 2004
Loading...

Share This Page