Migration issue from DTS 2000 to SSIS SQL 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Migration issue from DTS 2000 to SSIS SQL 2005

Author

Topic

vduggaraju
Starting Member

1 Post

Posted - 2007-07-13 : 14:27:08

Hi,

Hi,

I am trying to migrate DTS 2000 packages to SQL 2005 SSis using Package Wizard. When I am invoking and after the passing server information of source and destination, while reading the packages it is giving error

TITLE: Microsoft SQL Server

------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

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

Parameter name: index (mscorlib)

Could someone can help in this regards. As this is a important task for me and I am stuck on this which has to be resolved by end of today.

Thanks

-VD

Venkatesh

X002548
Not Just a Number

15586 Posts

Posted - 2007-07-13 : 15:11:57

Yeah, re-write it using T-SQL, bcp and don't use SSIS?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources