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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 deploy

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2013-03-16 : 16:53:46
hi

i 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2013-03-17 : 16:54:43
yes
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2013-03-19 : 11:29:26
how can i compare with vss?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -