dbTalk Databases Forums  

Saving of a DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Saving of a DTS Package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ReportFAQGuy
 
Posts: n/a

Default Saving of a DTS Package - 10-19-2004 , 12:05 PM






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

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Saving of a DTS Package - 10-19-2004 , 12:21 PM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.