DTS packages are kept on the server but you can save them (design package/ save package as) to a local or network drive as a visual basic package (.bas, a text file which can then be added to stuff like MSAccess to execute).
You find them in Enterprise Manager under Data Transformation Services.