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 |