I've been migrating SQL 2000 DTS packages into SQL 2005 using the Migrate DTS 2000 Package wizard in Visual Studio 2005. All packages migrate fine except one which throws out the following error:
exception of type 'Microsoft.SQLServer.DTS.MigrationWizard.HelperUtility.DTSMWException was thrown
No other supporting information is given to help diagnose the problem. Has anyone else come across this error before? Looking at past threads, I've checked the DTS package for leading or trailing spaces which might cause an issue and there are none.
Thanks.
me too in the same position...|||Hey i found the problem. if you are package is Incompleted take an example "doing the bulk insert from SQL Server Conn to Excel sheet but with out Defining which Table and column" package will thro error. Just check you package.
No comments:
Post a Comment