Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2013-03-16 : 16:53:46
|
| hii use BIDS Helper to deploy my package to MSDB folder.how can i sign the package that i deploy, i mean how can i know what is the version of package i have in ssis ,and the version of the same package in my MSDB folder. thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-17 : 13:31:59
|
| do you've a version management software like VSS/SVN?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-03-17 : 16:54:43
|
| yes |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 13:08:50
|
| then that should be used for storing versions. MSDB doesnt support versioning.versioning is available in SSIS 2012 when you use project deployment model though.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-03-18 : 13:40:48
|
| Is any solution to know what is lasted version ssis package that i deployed to MSDB? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-18 : 14:03:42
|
| only way is to import it to local machine and then compare it with other versions you've using file compare software------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2013-03-19 : 11:29:26
|
| how can i compare with vss? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-19 : 11:48:15
|
| select the required version and choose view difference option------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
deploy