<anonymous@discussions.microsoft.com> wrote in message
news:825c01c40394$36a4a720$a401280a@phx.gbl...
> 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,
>
>
>
>
>
>
> >-----Original Message-----
> >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@discussions.microsoft.com> wrote in message
> >news:788301c402c5$cb7f7fc0$a301280a@phx.gbl...
> >> 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,
> >>
> >>
> >
> >
> >.
> >