No. This is a known problem with saving packages this way, all layout
information including annotations is lost.
If you are just moving packages you can copy directly between
sysdtspackages, but not changes can be made enroute.
Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)
--
Darren Green
http://www.sqldts.com
"ReportFAQGuy" <ReportFAQGuy (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi
I am using a vb program to Open a package from a SQl
Server(obj.LoadFromSQLServer) and then save it back to another server. The
only problem with that is that the format of the package(layout) gets
disturbed on the new server. I know the thing happening here is that the
package is saved on the new server with AutoLayout applied.
Is there any way that we can preserve the format(layout) of the various
conns and tasks etc. while saving programatically.
Any help would be appreciated.
ReportFAQGuy |