Tuesday, March 27, 2012

DTS Question ...

I have SQL 2000 Enterprise Manager on a desktop development machine .. will
I be able to use DTS from this machine if we upgrade to SQL 2005 on the
server; the reason I'm asking is that I think the "upgrade" (with Small
Business Server) is going to be to the Workgroup Edition, which I don't
think has DTS in the box ... or does it ?
Thanks in advance ...
LLiz wrote:
> I have SQL 2000 Enterprise Manager on a desktop development machine .. wil
l
> I be able to use DTS from this machine if we upgrade to SQL 2005 on the
> server; the reason I'm asking is that I think the "upgrade" (with Small
> Business Server) is going to be to the Workgroup Edition, which I don't
> think has DTS in the box ... or does it ?
> Thanks in advance ...
> L
>
>
DTS no longer exists in SQL Server, it is replaced with Integration
Services in SQL 2005.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eYtkiBIpGHA.220@.TK2MSFTNGP05.phx.gbl...

> Liz wrote:
will[vbcol=seagreen]
> DTS no longer exists in SQL Server, it is replaced with Integration
> Services in SQL 2005.
yeah, but DTS exists on my desktop .. or does it ? I never once thought
about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
with a SQL 2005 back end ?|||Liz wrote:
> yeah, but DTS exists on my desktop .. or does it ? I never once thought
> about it ... is it not able to talk to SQL 2005 ? Can you use EM at all
> with a SQL 2005 back end ?
>
>
No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
that is a server component. And no, you'll have a hard time getting
Enterprise Manager to work with a 2005 server.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
> Liz wrote:
> No, the DTS DESIGNER exists on your desktop, the DTS engine does not,
> that is a server component. And no, you'll have a hard time getting
> Enterprise Manager to work with a 2005 server.
but the on the MS site today I saw in a SQL 2005 WG ED. summary that you can
download DTS for use with it ... ' (in addition to whatever the
import/export facilities that are native to the WG Edition (and other
editions I presume))|||Liz wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:OuYToQOpGHA.4192@.TK2MSFTNGP03.phx.gbl...
> but the on the MS site today I saw in a SQL 2005 WG ED. summary that you c
an
> download DTS for use with it ... ' (in addition to whatever the
> import/export facilities that are native to the WG Edition (and other
> editions I presume))
>
>
You can download the DTS DESIGNER to use with the new Management Studio
- this is not the DTS engine. All this does is allow you to connect to
SQL 2000 servers to edit legacy DTS packages.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:eVabsvapGHA.4760@.TK2MSFTNGP05.phx.gbl...

can[vbcol=seagreen]
[vbcol=seagreen]
> You can download the DTS DESIGNER to use with the new Management Studio
> - this is not the DTS engine. All this does is allow you to connect to
> SQL 2000 servers to edit legacy DTS packages.
jeez ... they don't do much of a job explaining that in the feature summary
...
here's a quote:
"You can also run packages that were created by using SQL Server 2000 tools
as part of a SQL Server 2005 data transformation solution. Integration
Services provides the Execute DTS 2000 Package task for running DTS packages
from within SQL Server 2005 Integration Services packages."
http://msdn2.microsoft.com/en-us/library/ms143706.aspx
that sure makes it sound like you can run a DTS package against SQL2005 data
... it's not completely unambiguous BUT ...
Thanks, Tracy ...
L|||Liz wrote:
> jeez ... they don't do much of a job explaining that in the feature summar
y
> ...
> here's a quote:
> "You can also run packages that were created by using SQL Server 2000 tool
s
> as part of a SQL Server 2005 data transformation solution. Integration
> Services provides the Execute DTS 2000 Package task for running DTS packag
es
> from within SQL Server 2005 Integration Services packages."
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
> that sure makes it sound like you can run a DTS package against SQL2005 da
ta
> ... it's not completely unambiguous BUT ...
> Thanks, Tracy ...
> L
>
You can run an existing DTS package (imported from a SQL 2000 instance)
as a task inside an SSIS project. You can't create new DTS packages as
they existed in SQL 2000, that whole concept has been replaced with
SSIS. It's much more powerful than DTS was, you should spend some time
exploring its capabilities.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment