Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Using Constants in DTS

    I am really new to DTS but I have had moderate success creating packages to move and tranform data in one DB to a new DB. The problem I am having is that I can not figure out how to use a constant in my transformation.

    I am moving data from an old DB to a new DB. Currently all of my users in the old DB will have the same user role in the new DB. So I basically want to move all of my user ids to a lookup table and then give them all the same role id. Seems like it should be easy, but no luck here.

    Does anyone have some advice?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You can't just script the users from the old database, then play the script into the new database ?!?

    What exactly do you mean by the phrase "user id"? Do you mean the value in the system tables? If so, it is a bad plan to even worry about those values.


Posting Permissions

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