Import data with SQL DTS package

Need to actually run through this and update notes.

When I was testing my Commvault mp I had to constantly refresh data from a prod SQL table to my test SQL table. This is laborious and can be streamlined a bit using SQL DTS package.

To create the DTS package just follow the wizard. I then created a file in C:\temp called _dummy_jobs.csv. Run this to import (update filename/path as needed).

dtexec /F d:\mp\Anthony\DTS1.dtsx