editing Transact-SQL in a DTS Package

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello, I have a question regarding a Tip given in SQL Server 7.0 System Administration Training Kit, Microsoft Press. On Page 148, Chapter 6 Transferring Data, there is a Tip: When copying a table, the DTS wizards by default do not copy indexes, triggers, or contraints. If the table is to be created by the package you can manually edit the Transact-SQL that is used to create the table and add the statements needed to create indexes, triggers and constraints.

I have tried to figure out how to do this and also searched Books Online and Technet. I have not been able to edit the script. Could you please tell me how I can do this?

Yours Truly, Paul Tribe

-- Anonymous, February 11, 2000

Answers

Paul,

Once the Data Transformation package has been created, find it with SQL Enterprise Manager under Data Transformation Services, Local Packages or Data Transformation Services, Repository Packages. Then double click on the package name to get into the package designer. Then double click on the line between the two databases. This allows you to edit the "Data Transformation Properties". You will thus be looking at the Transact SQL code that you can edit.

Good Luck,

Eric

-- Anonymous, February 13, 2000


Moderation questions? read the FAQ