Posted on 2010-04-06
Medium Priority
Last Modified: 2013-11-30
In DTS packages when you right click on it, you find "Versions..". What is the equivalent of that in SSIS? When you save a package as a file, you really dont have different versions in SSIS. Is there a way to do that or save that?
Question by:MayankSql
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 29930554

Author Comment

ID: 29933416
I was not talking about those Versions. I am talking about like in SSIS you have version number stored after each time you save a package you get assigned a different version(can be seen under Properties window in SSIS package the lower most window)
In DTS you can call your older version(Can u?) or it just stores version numbner. File attached.

Author Comment

ID: 29933483
If you click on Versions, does it stores different DTS packages each time you modify a package or just history and different version numbers?
LVL 75

Accepted Solution

Anthony Perkins earned 500 total points
ID: 30016586
When using SSIS you can use any version control application such as Visual SourceSafe which is integrated with SSIS.

Assisted Solution

grzegorzs earned 500 total points
ID: 30114652
A new version of a DTS package is created when you save it. Package versions (files) are stored in the sysdtspackages table in the msdb database. Each version is stored in its own row in this table. You can delete unnecessary version from Enterprise Manager (Versions...) or directly from the sysdtspackages table.

In SSIS 2005/2008 packages you have some properties for storing version number (major, minor, build). But for storing old version you have to use version control system.

I use open source: Subversion and Ankh plug-in for Visual Studio.

best regards

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question