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?