mssql

It’s usually a good idea to schedule regular refreshes of a development (dev) sql server from the production(prod) version. Ideally, the prod environment is secured from everyone except an isolated number of systems administrators requiring dev to be kept as close to the live version as possible.

DTS's were so... simple, but with a more robust implementation comes complexity. Using Microsoft’s SQL Server Business Intelligence Studio you can create powerful automated packages known as SSIS packages which have taken the place of the DTS. To get started select new project from the File menu and choose Integrated Services project.