Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Layout and textannotations gone from package after loading

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-10 : 06:49:34
Arie writes "Hi,

I use a script (which can be found at http://www.nigelrivett.net/DTS/s_LoadPackageToServer.html) to load a dts package to server using the sp_OACreate 'DTS.Package' and sp_OAMethod 'Load from StorageFile' method. The script works fine, but the text annotations I made in the package and the layout are gone after saving to server.
If I manually load the package, simply by opening it from Enterprise manager, the layout and annotations are there, so I'm sure it is somehow stored in the structured storage file.
Is there a way (other than manually load the packages) to solve this problem???

Hope you can help,

thnx in advance,

Arie"
   

- Advertisement -