Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package Version Archives In MSDB Expand / Collapse
Author
Message
Posted Friday, November 2, 2007 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 8:09 AM
Points: 1, Visits: 208
If I were to edit an existing legacy DTS package either in SQL 2000 or 2005 the older versions would be saved to the server in MSDB. If for some reason I need to revert back to an older version of the package I have the luxury of opening the older version of the package and re-saving as current. I am unsure how to accomplish this with SSIS packages stored in the MSDB as if I were to import a package with the same name of an existing package in the MSDB it overwrites it. Is there the ability to accomplish this archived versioning in SSIS like with legacy DTS?
Post #418003
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse