Post reply

DTS deletion

  • February 8, 2011 at 3:35 am

    #143243

    As we migrating from sql 2005 to 2008 , in sql 2005 consists of around 200 packages , instead of deleating one by one how can we delete all packages at a time ?

  • February 8, 2011 at 5:08 am

    #1283606

    ramyours2003 (2/8/2011)

    As we migrating from sql 2005 to 2008 , in sql 2005 consists of around 200 packages , instead of deleating one by one how can we delete all packages at a time ?

    The SSIS 2005 packages are stored in the msdb.dbo.sysdtspackages90 table. Delete the rows there to delete your packages.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply