Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    22

    Unanswered: How to pass multiple Parameters to a DTS Package through command prompt in SQL 2000?

    How to pass multiple Parameters to a DTS Package through command prompt in SQL 2000?

    Could any body give sample

    using dtsrun and /A switch

    Thanks in Advance,
    Sateesh.

  2. #2
    Join Date
    Sep 2003
    Posts
    212

    Re: How to pass multiple Parameters to a DTS Package through command prompt in SQL 2000?

    Originally posted by sateesh
    How to pass multiple Parameters to a DTS Package through command prompt in SQL 2000?

    Could any body give sample

    using dtsrun and /A switch

    Thanks in Advance,
    Sateesh.
    @ECHO Off
    set myserver=S2K-DBASRV\SQL2000
    set mydb=Compensation
    set extractdir=C:\Extracts
    set outdir=./output

    CALL dtsrun /F%1 /N%1 /WTRUE /A”Database:8=%mydb%” /A”ServerName:8=%myserver%” /A”Outfile:8=%extractdir%\%~1.txt” > “%outdir%\%~1.txt”


    TIME /T
    ECHO %1 Completed
    @ECHO ON


    save this and run it as rundts.bat

    Hope this helps

  3. #3
    Join Date
    Sep 2003
    Posts
    22

    Re: How to pass multiple Parameters to a DTS Package through command prompt in SQL 2000?

    Thank You

    I will try with this example

    Regards,
    Sateesh


    Originally posted by vmlal
    @ECHO Off
    set myserver=S2K-DBASRV\SQL2000
    set mydb=Compensation
    set extractdir=C:\Extracts
    set outdir=./output

    CALL dtsrun /F%1 /N%1 /WTRUE /A”Database:8=%mydb%” /A”ServerName:8=%myserver%” /A”Outfile:8=%extractdir%\%~1.txt” > “%outdir%\%~1.txt”


    TIME /T
    ECHO %1 Completed
    @ECHO ON


    save this and run it as rundts.bat

    Hope this helps

Posting Permissions

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