DTS and sql scripting (TSQL/SP)

What are the advantageous of using a DTS package over
scripting the tables for data migration needs. We have
some architectural decisions to make and would someone to
throw light on why one should not use DTS as much as
scripting. People at work are DTS alergic. I personally
think DTS would be easier to develop other than the
learning curve invoved in learning VBScript and that it
cannot be executed from cmd.

SQL Gurus please help !

Thanks,

DTS for me is good because the experience is visual. You can write packages
that handle the errors, have precedence constraints, are very dynamic, are
fast, embed complex logic and are relativley easy to see which parts fail.

When would I not use DTS. I wouldn't use DTS if I wanted to move the whole
database. I would use BACKUP and RESTORE

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"k" <anonymous (AT) discussions (DOT) microsoft.com> wrote

We have people in our team who has had difficulties in
mirgrating the DTS packages between the different
environments. They are afraid to go with DTS for that
reason. Is there any documentation link which you can
point to, which talks about DTS package migration and
configuration issues.

Thanks,

From Allan and Darren's website - http://www.sqldts.com/Default.aspx?204

--
Ray Higdon MCSE, MCDBA, CCNA
---
<anonymous (AT) discussions (DOT) microsoft.com> wrote