On the next screen, check only: one in the "Create Destination Objects..." - one in the "Copy Data -Replace all Data..." - and one in "Copy all objects...". 

In the box "Use Default Options", uncheck it and click the "Options" button. In the following window, clear all of the Security check boxes. 

Click OK, Next, Next and Finish.

This way all tables, views and stored procedures are transferred into the SQL Server Database!

User Comments How to get MSSQL DTS working?
There are no user comments for this topic.