I'm trying to deploy patches to my SMS 2003 Clients that are members of my ConfigMgr Site but I'm seeing the following errors in my Wsyncmgr.log:

Performing legacy sync STATMSG: ID=6709 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" …
Started with command line: C:\Program Files\Microsoft Configuration Manager\bin\i386\updatewuscatalog.exe …
Processing security catalog C:\Program Files\Microsoft Updates Inventory Tool\PkgSource\wsusscn2.cab ...
Initializing catalog C:\Program Files\Microsoft Updates Inventory Tool\PkgSource\wsusscn2.cab for synchronization.
Pre-processing updates...
Error 0x80004005, Unexpected DeploymentAction for update 1293995. Returned from CreateUpdateNode
Updates summary: 0 processed, 0 matched, 0 outdated, 0 updated

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
This problem was first discovered with the June 2008 Patch release.  Microsoft added some additional metadata to the "Wsusscn2.cab" file for Office 2003 SP1.  This additional metadata broke the "UpdateWUSCatalog.exe" which manages the catalog synchronisation process.

Microsoft has released an updated version of this file available under KB article 954474 "System Center Configuration Manager 2007 blocked from deploying security updates" which also contains full details of the issue.

NOTE: This problem only affects ConfigMgr RTM/ SP1 Sites that are deploying to SMS 2003 Clients.  If you're running either a pure ConfigMgr environment or pure SMS 2003 environment then you won't see this issue.