Showing posts with label migrate. Show all posts
Showing posts with label migrate. Show all posts

Friday, March 9, 2012

DTS 2000 Migration Issue

Hi ,
I am trying to Migrate DTS 2000 package to SQL 2005.

I am opening the wizard form SQL Server Management Studio>Object Explorer>Management->Legacy->DTS ->Migration Wizard .

when i run the wizard with source location than folder destination .

In the third step of the wizard i am getting an error saying :

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)

Please advice me how to proceed ?

Thank you

Syeda

This is a known issue. See:

http://support.microsoft.com/kb/917420/en-us

Sunday, February 26, 2012

DTS

Hello Group,
I would like to know if DTS can be used to migrate data
from db2 to sqlserver2000.
Any pointers would be great!!
Thanks for the help,
Chris.See if this helps -
http://databasejournal.com/features/mssql/article.php/1444051 I would also
check sqldts.com
Ray Higdon MCSE, MCDBA, CCNA
--
"chris" <chris@.nospam.com> wrote in message
news:2QGPb.5113$ro4.79@.nwrdny02.gnilink.net...
> Hello Group,
> I would like to know if DTS can be used to migrate data
> from db2 to sqlserver2000.
> Any pointers would be great!!
> Thanks for the help,
> Chris.
>

Friday, February 24, 2012

DTS

Hello Group,
I would like to know if DTS can be used to migrate data
from DB2 to sqlserver2000.
Any pointers would be great!!
Thanks for the help,
Chris.See if this helps -
http://databasejournal.com/features...cle.php/1444051 I would also
check sqldts.com
Ray Higdon MCSE, MCDBA, CCNA
--
"chris" <chris@.nospam.com> wrote in message
news:2QGPb.5113$ro4.79@.nwrdny02.gnilink.net...
quote:

> Hello Group,
> I would like to know if DTS can be used to migrate data
> from DB2 to sqlserver2000.
> Any pointers would be great!!
> Thanks for the help,
> Chris.
>