Using the DTS Wizard, I want to take the data from one denormalized (source) table and import it into multiple destination tables. Is this possible?
Printable View
Using the DTS Wizard, I want to take the data from one denormalized (source) table and import it into multiple destination tables. Is this possible?
On 11/6/98 5:32:59 PM, M. Diebolt wrote:
> Using the DTS Wizard, I want to take the data from one denormalized
> (source) table and import it into multiple destination tables. Is this possible?
It is possible, however you must use the DTS Package Designer and not the wizards. Using the DTS Package Designer gives you the flexability to specify multiple source and destinations as well as more advanced scripting functionality. In SQL7 expand your server, go to the DTS Folder, right click and select package designer.