Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Unanswered: STORE PROCEDURE and DTS

    I created a batch file to run a DTS saved as a STRUCTURED STORE FILE. Works fine on the command promt.

    Can I use a SPROC to call something like a shell command to execute that batch file? If yes, how is this be possible?

    Thanks

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by ARPRINCE
    I created a batch file to run a DTS saved as a STRUCTURED STORE FILE. Works fine on the command promt.

    Can I use a SPROC to call something like a shell command to execute that batch file? If yes, how is this be possible?

    Thanks
    check this out..
    EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -i [input_file]
    Joydeep
    Last edited by rudra; 03-13-06 at 18:51.

  3. #3
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Thumbs up

    Quote Originally Posted by rudra
    check this out..
    EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -I [input_file]
    Joydeep

    Thanks for the input. It worked for me without the other parameters.

    EXEC master..xp_cmdshell 'C:\DatabaseDTS\MYBATCH.BAT'

Posting Permissions

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