dbTalk Databases Forums  

Lost package info when we use

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


Discuss Lost package info when we use in the microsoft.public.sqlserver.dts forum.



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

Default Lost package info when we use - 06-23-2004 , 04:09 PM






When i use this code

Dim objLotDts As New DTS.Package2

objLotDts.LoadFromStorageFile strNomLotDTS

objLotDts.SaveToStorageFile vstrNomFichierDTS

Set objLotDts = Nothing

I lost the comment put in the DTS package and all the task in this DTS changing place (rearrange)???


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

Default Re: Lost package info when we use - 06-24-2004 , 12:55 AM






In message <FF348F72-3FC6-4E8C-8D05-9F894275C7F1 (AT) microsoft (DOT) com>, Bernard
<Bernard (AT) discussions (DOT) microsoft.com> writes
Quote:
When i use this code

Dim objLotDts As New DTS.Package2

objLotDts.LoadFromStorageFile strNomLotDTS

objLotDts.SaveToStorageFile vstrNomFichierDTS

Set objLotDts = Nothing

I lost the comment put in the DTS package and all the task in this DTS
changing place (rearrange)???


This is a known issues with DTS. The object model does not support, or
even preserve the layout information, which includes task positions on
the design sheet and annotations.

Sorry, no workaround is available.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
  #3  
Old   
Paul
 
Posts: n/a

Default Re: Lost package info when we use - 06-24-2004 , 06:55 PM



Bernard:

This may help shed some light.

http://support.microsoft.com/default...b;en-us;249901

Paul

"Bernard" <Bernard (AT) discussions (DOT) microsoft.com> wrote

Quote:
When i use this code

Dim objLotDts As New DTS.Package2

objLotDts.LoadFromStorageFile strNomLotDTS

objLotDts.SaveToStorageFile vstrNomFichierDTS

Set objLotDts = Nothing

I lost the comment put in the DTS package and all the task in this DTS changing place (rearrange)???

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.