473,320 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Where is my dts?

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.

Feb 9 '07 #1
4 9135
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

<ot*******@yahoo.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.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.
Feb 9 '07 #2
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.comwrote in message

news:11**********************@k78g2000cwa.googlegr oups.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 -

Feb 12 '07 #3
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.comwrote in message
news:11**********************@k78g2000cwa.googlegr oups.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 -

Feb 12 '07 #4
To edit legacy DTS packages from SQL Server Management Studio, you need to
download and install the SQL Server 2000 Designer components. This is one
of the Feature Pack downloads available at
http://www.microsoft.com/downloads/d...displaylang=en

SSIS packages are created using the separate SQL Server Business
Intelligence Development Studio IDE rather than within SSMS. Although there
is a learning curve to get up to speed on SSIS, it is much more powerful
than DTS. Consider doing new development under SSIS rather than DTS.
--
Hope this helps.

Dan Guzman
SQL Server MVP

<ot*******@yahoo.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...
>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.comwrote in message
>news:11**********************@k78g2000cwa.googleg roups.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 -

Feb 12 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

47
by: Andrey Tatarinov | last post by:
Hi. It would be great to be able to reverse usage/definition parts in haskell-way with "where" keyword. Since Python 3 would miss lambda, that would be extremly useful for creating readable...
3
by: A.V.C. | last post by:
Hello, I found members of this group very helpful for my last queries. Have one problem with CASE. I can use the column name alias in Order By Clause but unable to use it in WHERE CLAUSE. PLS...
3
by: Xiangliang Meng | last post by:
Hi, all. In 1998, I graduated from Computer Science Dept. in a university in China. Since then, I've been using C Language for almost 6 years. Although I'm using C++ in my current job, I'm also...
7
by: Britney | last post by:
Original code: this.oleDbSelectCommand1.CommandText = "SELECT TOP 100 user_id, password, nick_name, sex, age, has_picture, city, state, " + "country FROM dbo.users WHERE (has_picture = ?) AND (sex...
5
by: comp.lang.php | last post by:
if ($willLimitByDB) $sql = preg_replace('/#(+)#/i', '$$1', $sql); This does not give me the results I want, instead of the value of $where in $sql, I literally get '$where' instead. How do I...
5
by: John | last post by:
I just cannot manage to perform a SELECT query with NULL parameter... My CATEGORY table does have one row where TCATEGORYPARENTID is null (real DB null value). TCATEGORYID and TCATEGORYPARENTID...
0
NeoPa
by: NeoPa | last post by:
Background Whenever code is used there must be a way to differentiate the actual code (which should be interpreted directly) with literal strings which should be interpreted as data. Numbers don't...
1
by: not_a_commie | last post by:
I was hoping for increased functionality with the where clause in C# 3.0. Using the new keyword 'var' would really allow us to take nice advantage of these. Specifically: 1. I want to limit it...
9
by: Emin | last post by:
Dear Experts, I have a fairly simple query in which adding a where clause slows things down by at least a factor of 100. The following is the slow version of the query ...
8
by: chrisdavis | last post by:
I'm trying to filter by query or put those values in a distinct query in a where clause in some sort of list that it goes through but NOT at the same time. Example: ROW1 ROW2 ROW3 ROW4 ,...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.