So for the last couple days I have been trying to get this to work and finally it hit me what I was doing wrong. If you want to set this up all you need to do is first use an MDT imported Task Sequence into SCCM so it takes advatange of the MDT scripts and settings. This will setup a task in your task sequence called Install Software and the settings should already be set to the Install Multiple Applications option with the Base property being PACKAGES (Which we all know is the property BDD/MDT uses to assign SMS packages). Second is you can simply follow the documentation in the Deployment Customization Desktop Samples doc that is included in the Microsoft Deployment Tools install. The section is called Deploying Applications Based on Previous Application Versions on page 39.
What is the trouble you ask? Well if you are like me and have never set this or even referenced a SMS package and program combo via BDD or MDT before then you’ll probably just follow the documentation word for word. And here is the key problem! The documentation gives the following example for putting a package into your PackageMapping table:
INSERT INTO [PackageMapping] (ARPName, Packages) VALUES(‘Office8.0’, ‘XXX0000F-Install Office 2003 Professional’)
Those that are familiar with referencing SMS packages in their customsettings.ini or their BDD database will instantly spot the flaw with this syntax. They are mapping to the Office 2003 Profession install using the [PACKAGEXXX-Program] format (notice the dash) when in fact it is suppose to be a colon such as [PACKAGEXXX:Program]! So the correct example should look like this:
INSERT INTO [PackageMapping] (ARPName, Packages) VALUES(‘Office8.0’, ‘XXX0000F:Install Office 2003 Professional’)
Simple mistake yet I should’ve noticed this right away since this is the format displayed in the BDD console you when use the Add Package option in the database section.
The documentation references the same syntax error again in the same section as noted below. Just keep in mind it should be a colon and not a dash and you will be in good shape.
(XXX0000F-Install Office 2003 Profession). This indicates that package XXX0000F-Install Office 2003 Professional will be installed by the ZTI process during the State Restore Phase.