SaveToSQLserverAs Method of the Package2 Object (DTS in SQL-Server)

  • Hi all

    See if anyone has a clue on this one. 

    When you create a DTS Package in SQL-Server Environment, you can add Tasks, Connections, Transformations and other goodies. One of many interesting objects you can also add are "Text Annotations".  Also, every object that you add is placed on the package in a specified location so that the next time you open SQL-Server DTS Package you will find things as you left them as supposed to in a big mess. 

    Guess what...! When I use the "SaveToSQLServer" method of the "Package2" Object in VB.net to generate a copy of the DTS Package just created, the new package has lost all the layout and "Text Annotations" information that I so hard tried to create in the original package. How the hellllllll can I prevent such mischiefs from happening? 

    Sincerely yours...

  • ever get an answer to this one?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply