Packages internall retain "history"?

Discussion in 'microsoft.public.sqlserver.dts' started by Vern Rabe, Jul 11, 2010.

  1. Vern Rabe

    Vern Rabe Guest

    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
     
    Vern Rabe, Jul 11, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.