dbTalk Databases Forums  

Packages internall retain "history"?

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


Discuss Packages internall retain "history"? in the microsoft.public.sqlserver.dts forum.



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

Default Packages internall retain "history"? - 07-11-2010 , 03:44 PM






SQL 2005 SSIS. I will often query the msdb.dbo.sysdtspackages90 table,
looking at the packagedata column, for references to objects. If I have a
deprecated table, for instance, I'll find all packages where that table name
is in the packagedata column, and I'll then edit the packages to no longer
reference the table. Once I've modified the package, and deployed to SQL
Server, the packagedata column still has a reference to the table. It's as
if the package retains all previous versions. Is there any way to flush
those out of a package?

Thanks
Vern Rabe

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.