DTS Wizard error

[jfield817]

(using sql server 7.0)
The DTS Wizard errors out with the following msg at the end of the process ..(import from 1 server to a local one)

"Failed to transfer objects from Microsoft SQL Server to Microsoft SQL Server"

thanks
john field

 

[foxdev]

You may get a list of steps, with one of them having a red symbol; double-clicking on that will reveal more details about the error.

One that that often causes these errors is you are using the default options; uncheck the Use Default Options box, then deselect the options related to transporting users and rights. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Bernadette]

After you fix your dts errors and transfer your objects with DTS -if you have not transferred them with User Rights and OBject Permissions you will have to re-set your permissions. It is handy to have a script file with User RIghts and Permissiosn on hand to do this. You can create it by using the "Generate Scripts ...." tool. Hope This Helps
Bernadette