SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 deploy		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

inbs
Aged Yak Warrior

811 Posts
Posted - 03/16/2013 :  16:53:46  Show Profile  Reply with Quote
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

India
47038 Posts
Posted - 03/17/2013 :  13:31:59  Show Profile  Reply with Quote
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

811 Posts
Posted - 03/17/2013 :  16:54:43  Show Profile  Reply with Quote
yes
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47038 Posts
Posted - 03/18/2013 :  13:08:50  Show Profile  Reply with Quote
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

811 Posts
Posted - 03/18/2013 :  13:40:48  Show Profile  Reply with Quote
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

India
47038 Posts
Posted - 03/18/2013 :  14:03:42  Show Profile  Reply with Quote
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

811 Posts
Posted - 03/19/2013 :  11:29:26  Show Profile  Reply with Quote
how can i compare with vss?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47038 Posts
Posted - 03/19/2013 :  11:48:15  Show Profile  Reply with Quote
select the required version and choose view difference option

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000