You are here: Re: Where is my dts? « MsSQL Server « IT news, forums, messages
Re: Where is my dts?

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 -

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация