Friday, March 23, 2012

Package MajorVersion and MinorVersion, when do they change?

HI, I am wondering when those system variables change. I just cannot see when these are updated. Also, VersionComment, whta is the purpose of this?

Thank you,

Ccote

You change them. For your own version control system.|||

Thanks, is there a way to change those properties via VSS? Or maybe I do not unerstand.

Ccote

|||

No, you would update the values on the properties through BIDS. It is so you can set your own version numbers.

|||

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

|||

ccote wrote:

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

"Major" version might be a complete overhaul of logic. Perhaps you've restructured the way totals are calculated and are now performing via new business rules.

"Minor" version might be a minor change -- a where clause addition, fix a typo, etc...

In the end, it's up to you.|||

ccote wrote:

OK I saw it, thanks! What would be the difference (or usage of) between Major and Minor version? And also, is there a way to set these properties via a script task? Open all packages and set properties?

Thanks again!

Ccote

You can use the SSIS API to load packages and set the properties, then save the packages again, if you want to automate the process.

|||

Ok thanks guys!

No comments:

Post a Comment