DTS Scripts

We are upgrading our current SQL2000 Server to new hardware. Is there a way
to transfer DTS packages from one server to another. Thanks.
Open the package, in the package menu, select save as...you can save it to
file or directly to another server
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl...
> We are upgrading our current SQL2000 Server to new hardware. Is there a
> way
> to transfer DTS packages from one server to another. Thanks.
>
|||did you hear "Tom Reis" <reistom@.cdnet.cod.edu> say in
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl:

> We are upgrading our current SQL2000 Server to new hardware. Is there
> a way to transfer DTS packages from one server to another. Thanks.
>
http://www.sqldts.com/default.aspx?204
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs
|||HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
AMB
"Tom Reis" wrote:

> We are upgrading our current SQL2000 Server to new hardware. Is there a way
> to transfer DTS packages from one server to another. Thanks.
>
>
|||Hi,
Just open the DTS Package and save the package in text file it will be
saved as ii.DTS.
Copy that to another server and open the package and save in local
machine.
hope this help u
from
Doller
sqlsql

DTS Scripts

We are upgrading our current SQL2000 Server to new hardware. Is there a way
to transfer DTS packages from one server to another. Thanks.Open the package, in the package menu, select save as...you can save it to
file or directly to another server
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl...
> We are upgrading our current SQL2000 Server to new hardware. Is there a
> way
> to transfer DTS packages from one server to another. Thanks.
>|||did you hear "Tom Reis" <reistom@.cdnet.cod.edu> say in
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl:

> We are upgrading our current SQL2000 Server to new hardware. Is there
> a way to transfer DTS packages from one server to another. Thanks.
>
http://www.sqldts.com/default.aspx?204
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
AMB
"Tom Reis" wrote:

> We are upgrading our current SQL2000 Server to new hardware. Is there a wa
y
> to transfer DTS packages from one server to another. Thanks.
>
>|||Hi,
Just open the DTS Package and save the package in text file it will be
saved as ii.DTS.
Copy that to another server and open the package and save in local
machine.
hope this help u
from
Doller

DTS Scripts

We are upgrading our current SQL2000 Server to new hardware. Is there a way
to transfer DTS packages from one server to another. Thanks.Open the package, in the package menu, select save as...you can save it to
file or directly to another server
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl...
> We are upgrading our current SQL2000 Server to new hardware. Is there a
> way
> to transfer DTS packages from one server to another. Thanks.
>|||did you hear "Tom Reis" <reistom@.cdnet.cod.edu> say in
news:uq4MB3IuFHA.3568@.TK2MSFTNGP10.phx.gbl:
> We are upgrading our current SQL2000 Server to new hardware. Is there
> a way to transfer DTS packages from one server to another. Thanks.
>
http://www.sqldts.com/default.aspx?204
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"Tom Reis" wrote:
> We are upgrading our current SQL2000 Server to new hardware. Is there a way
> to transfer DTS packages from one server to another. Thanks.
>
>|||Hi,
Just open the DTS Package and save the package in text file it will be
saved as ii.DTS.
Copy that to another server and open the package and save in local
machine.
hope this help u
from
Doller

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS Migration from SQL Server 2000

I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.

Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs:

This wizard will close because it encountered the following error:

Additional Information:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Also when trying to open a structured storage DTS file I incur another error:

Unable to load DTS 2000 Runtime. This component may have not been installed

(Microsoft.SqlServer.DtsObjectExplorerUI)

This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?

John,
The first error sounds like it *could* be a bug. Are you able to open a bug at betaplace?

Regarding your second error....you cannot open a DTS2000 package for editing using SQL Server 2005 tools so don't even bother trying. You need a SQL2000 instance in order to edit your DTS2000 packages.

Happily SQL2000 and SQL2005 can run alongside each other with one (or both) of them as a named instance.

-Jamie|||

Thanks Jamie,

I am not a member of betaplace. Could someone set me up with guest id to log the 1st problem as a possible bug? I’ll install an instance of SQL2000 to overcome the 2nd problem.

|||

Several forum users have reported the following error message when attempting to migrate a DTS package:

TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
...
ADDITIONAL INFORMATION:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)
...

One cause of this error, which can easily be reproduced, is a space before or (more likely) after the name of the package.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

|||

I have the same problem after uppgrading from Sql 2000 Personal to Sql 2005 Standard. The server has been uppgrade from win2000 standard server SP4 to win 2003 standard server SP1

In Mannagement > Legacy folder i'v have altso problems deleting old Mainenance plans. When I delete it it seems do disapair, but when i'm refresh it it comes back.

I have no space in the name of the DTS package

- Rolf

DTS in 2005

Hi all,

im starting to look into upgrading our Sql Server 2000 servers to Sql Server 2005. We have several DTS Packages that we use to import records into certain databases. Some are automated, but the majority of them are not. All of them are pretty complex in the amount of steps and operations they have to go through. I thought i heard that DTS packages were not supported in Sql Server 2005 anymore and i was wondering if this was true? Will my DTS packages be rendered useless if i upgrade to Sql Server 2005.

Also if anyone has a link to an article or site that discusses upgrading to 2005 from 2000 that would be great!

TIA,

mcm

You need for a download of SQL Server Feature Pack:

http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

There, você find Microsoft SQL Server 2000 DTS Designer Components. With DTS Designer Components you can edit and maintain existing DTS packages, but its not magic. In most cases, you need rebuild the packages.

|||I have installed the pack and now im able to edit sql2000 dts packages.