|
|
Posted by othellomy on 02/12/07 07:29
I think SQL Server 2005 is nothing but SQL Server 2000 Query Analyzer
*improved*. However, Server 2000 (Enterprise Manager) has lot more
features (for example dts) and SSIS is not the answer because when I
installed Server 2005 it don't get installed automatically.
On Feb 12, 10:05 am, othell...@yahoo.com wrote:
> Ok thanks. I am not very expert on dts but I followed your advice. I
> could not open the packages that were already developed in 2000. After
> I did a migration still no dts. When I try to open a package I get the
> message that "SQL Server 2000 Designer components are required.." etc.
> I did not upgrade from 2000 instead installed a new instance of Server
> 2005 so ended up running two different instances (one for 2000 and one
> for 2005). I am not sure if SSIS will give me the flexibility of
> developing simple dts using toolbox etc. Besides, installing SSIS is
> not easy either.
>
> On Feb 9, 6:40 pm, "Dan Guzman" <guzma...@nospam-online.sbcglobal.net>
> wrote:
>
>
>
> > DTS is replaced with SSIS (SQL Server Integration Services) in SQL 2005. If
> > you upgrade from SQL 2000, you'll find your old DTS packages in SQL Server
> > Management Studio Object Explorer under Management-->Legacy-->Data
> > Transformation Services. However, note that SQL Server 2005 includes DTS
> > only for backwards compatibility; it's recommended that you use SSIS for new
> > development.
>
> > See the SQL Server 2005 Books Online for more information
> > (http://msdn2.microsoft.com/en-us/library/ms143706.aspx).
>
> > --
> > Hope this helps.
>
> > Dan Guzman
> > SQL Server MVP
>
> > <othell...@yahoo.com> wrote in message
>
> >news:1171023589.200822.236990@k78g2000cwa.googlegroups.com...
>
> > > Why is dts packages out of server 2005? In server 2k they were there
> > > but in 2005 it's gone? I tried to connect to 2k using 2005 client
> > > interface and can't seem to locate the dts packages I seem to notice.- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
[Back to original message]
|