DTS Import/Export Wizard - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DTS Import/Export Wizard

Author

Topic

JeffT
Posting Yak Master

111 Posts

Posted - 2006-07-11 : 07:11:08

Hi,

I'm using the DTS Import/Export Wizard for the first time. Does anyone have a "canned" script I can run instead of going through the step by step wizard process. I have a number of tables I have to copy from a prod to test environment.

Thanks,
Jeff

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-11 : 07:15:54

You can use dmo
http://www.nigelrivett.net/DMO/SQL-DMOTransfer.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

JeffT
Posting Yak Master

111 Posts

Posted - 2006-07-11 : 08:57:19

Great ! Thanks nr,
Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources