SSIS in 2005 and DTS in 2000 are pretty different animals. While 2005
lets you continue to run your existing DTS packages, even aginst 2005
databases, what you cannot do is create new DTS, or even modify an
existing one ... there is no DTS designer in 2005.

SSIS is not just a rename or superset of DTS. Kent's source is correct
in that, going forward, there is not DTS ... only SSIS.

On 6/20/07, Duane Percox <[log in to unmask]> wrote:
> Kent wrote:
>
> >This is off topic.
> >
> >
> >
> >I understand DTS is not in SQL 2005.  Can anyone shed some
> >light on why this is happening and what DTS is replaced with??
> >
> >
> >
> >I have a lot of DTS.
>
> Your source is confused. And you should use Google and/or consult
> the MS SQL Server site before you accept such statements as being fact
> :-)
>
> Maybe they are trying to find it Visual Studio 2005 and can't find it.
> Ask them to see if they can see "SQL Integration Services"...
>
> duane
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>


-- 
"If hard work were such a wonderul thing, you'd think rich people
would have kept it all for themselves" - Lane Kirkland

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *