Finally, after searching, reading, and testing, I found a solution. Not entirely difficult either, but could take a while depending on how many you have to export. I did 111 in an hour.
I took the GUI macro tool approach. Downloaded a macro recorder from http://www.eventcorder.com/ec_downloads.htm, used the lite version, it's free.
Install recorder
Open SQL Server enterprise manager -> get to your local packages.
Now, you'll need to use the keyboard entirely to open,save and close, so try it out first.
I used the following keystrokes, to save a package currently highlighted in the local packages, in the right pane.
- {ENTER}
- {ALT + P}
- {ARROW KEY DOWN}
- {ARROW KEY DOWN}
- {ENTER} #at this point you should see "saving as"
- {TAB}
- {TAB}
- {TAB}
- {ARROW KEY DOWN}
- {ARROW KEY DOWN}
- {TAB}
- {TAB}
- {ENTER} #at this point you should see "saving as" dialog box, this defaults to your "my documents" folder
- {ENTER}
- {ENTER} #File saved
- {CTRL + F4}
- {ARROW KEY DOWN} # to start on new package
You should be ready to go, just click "Close", focus is given back to the eventcorder app. You should see your list of packages in the back of the eventcorder app, with the second package in the list selected, if not, make it so. Click "Play" --> "Repeatedly", and watch the magic happen. One thing to note, when it gets to the end there will be an issue, since it can't key down any further than the last item, it will open the last item and play the macro again. When it tries to save, the package will prompt you to overwrite the existing package. At this point I believe I {CTRL + ESC} to end the macro. Now check you "My documents" Folder, if all went well you should be smiling. If not, ... eh, review your process, sorry.
This is as accurate as i can get at the moment, I hope this helps.... This approach worked 100% for me, and I can recreate the whole process from scracth, so I know this works.