Help with DTS urgent

Results 1 to 2 of 2

Thread: Help with DTS urgent

  1. #1
    Join Date
    Dec 1969

    Default Help with DTS urgent

    Hi, i need with help with a DTS package that i am using. I need to know how i can use/mimic global variables in a DTS package. For example i need to store an email address in a variable, and in all the tasks/transformations of the package, i need to code so that if they fail, they send out an email. I dont want to hardcode the email address in each of the tasks, which would make modification very tough. There should be some way to get around this. Please help

  2. #2
    Richard A. Lowe Guest

    Default RE: Help with DTS urgent

    Yes, store the variables you want in a table! That&#039s really the best way I&#039ve found with DTS to insert configurable variables.<BR><BR>R.

Posting Permissions

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