Results 1 to 2 of 2

Thread: Basic DTS...

  1. #1
    Join Date
    Nov 2005

    Unanswered: Basic DTS...

    Hi all,

    am not very experienced in using DTS and really need your help. I have a dts package that i have scheduled to run every day. Here's what i want the package to do:

    1. Check whether a value for a certain column in a certain row of a table in my database is 0 or 1. If it is 1, then
    2. Run the dts task (which i have created and is working)

    In other words, when the package is started, i want to execute a stored procedure or sql task or whatever, and if that returns 1 then i want to continue, if it returns 0 i want to finish the package without running the dts task. I'm sure there's a simple way to do this, but i could use your help...!


  2. #2
    Join Date
    Jun 2003

    Thumbs up

    --call ur dts package from a sp, something like,
    exec master..xp_cmd_shell 'DTSRun /S MySQLServerName /E /N "Package Name"'
    I love cursor,though I never use it.Cos' I dont want to misuse it.


Posting Permissions

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