Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    3

    Unanswered: Brain Teaser: Help with old DTS package

    We have a very old DTS package that needs changing because the library name has changed for its destination table. However, we can't figure out how to change the library within the DTS package.

    We can see the bad library on the "Transform Data Task Properties / Destination / Table Name". However, we can't figure out how to change the table name. We don't need to create it - as it exists, but I believe the table in the wrong library may have been created via DTS originally and perhaps that is the reason why only it appears in the drop down?

    Nonetheless, we need to change the destination table library. Anyone remember how to do this?

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Can you include a print screen of it? It's hard for me to imagine what exactly you are referring to.
    ...
    library name has changed for its destination table
    ...
    the table in the wrong library
    ...
    You mean the table name or table owner name? Or the database name that holds that table?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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