I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.

I'm building out a new system with a database back-end that runs in multiple environments (DEV, INT, TST, PROD) and am looking for a tool to allow the DEV ...