The import/export wizard uses SSIS and allows you to save the package off. You could use that to do your first run, then save it off and use it for subsequent runs. This will allow you to parameterize some of the connection managers so you can point it to your different environments.