System:VersionGUID and multiple runs of the same package
I have an "engine block" package that is ran multiple times in parallel. I've set up some custom logging to keep track of package versions and I noticed that each time the package is ran, it generates a different VersionGUID but the VersionBuild is the same. Is this by design? Example: DataPumpVersionID DataPumpID PackageVersionGUID VersionMajor VersionMinor VersionBuild VersionComment EnteredDateTime -2147483424 -100 1CCFE9FC-F4D2-4D50-BBEE-92A2AB120D47 1 0 122 2012-08-31 09:39:30.123 -2147483422 -100 E3A2664D-2F0A-42C3-B483-BF8003D17F41 1 0 122 2012-08-31 09:39:44.767 -2147483421 -100 4A05E4E6-A66D-4905-A297-56AC9BC0E061 1 0 122 2012-08-31 09:39:58.610 -2147483420 -100 C5C521EF-F0F4-4F74-9ED2-EFAE0A203AB9 1 0 122 2012-08-31 09:40:13.607 -2147483419 -100 3F95FC7B-685C-4134-96B0-9EFE64C6081D 1 0 122 2012-08-31 09:40:29.257 -2147483418 -100 F984844F-0344-4817-A702-015979B59D50 1 0 122 2012-08-31 09:40:47.330 -2147483417 -100 DD635C3D-75B6-4852-8C78-8BFD28246784 1 0 122 2012-08-31 09:41:03.403 -2147483416 -100 312D4F2B-27E0-4414-8C11-416B51FD42AE 1 0 122 2012-08-31 09:41:17.887 -2147483415 -100 8ADD24CE-14B6-431F-8E88-62B1E1981958 1 0 122 2012-08-31 09:41:30.770 -2147483414 -100 A19EA822-A7FD-4A46-9D91-C936D07E93FA 1 0 122 2012-08-31 09:41:59.440 -2147483413 -100 B1A4567A-8D45-4F89-A907-EB3267A77275 1 0 122 2012-08-31 09:42:21.530 -2147483411 -100 8E06FBE4-D545-4605-9146-7F6ACB617427 1 0 122 2012-08-31 09:42:58.893
August 31st, 2012 10:05am

Hi there, VersionBuild gets updated whenever you make any changes & save package. Whereas, VersionGUID is unique for each execution of package.Thanks Prasoon
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2012 10:12am

The version of the package is the VersionBuild, so unless you generate the "engine block" in code (dynamically) it will remain static as set in BIDS at design time. And it can be manipulated there, too. With the VersionGUID the story is different, it simply gets generated by the SSIS engine using the standard .Net GUID Structure each time a package runs, it is a universally unique alphanumeric value. These two are completely unrelated. And, yes, this all is by design, you are right. Arthur My Blog
August 31st, 2012 10:17am

Thanks guys! Exactly what I was looking to hear.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2012 10:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics