SourceConnectionOLEDB is not found

[Picha Pie]

I'm trying to import data from one table in SQL Server 2000 to another table in SQL Server 2005. This are the same table and I was able to mapped the fields. But was getting this error:

The connection "SourceConnectionOLEDB" is not found. This error is throuwn by Connections collectoin when the specific connection is not found.

[rmiao]

Did you do that in sql2k5 BI studio or SSMS?

[Picha Pie]

I tried it in SSMS

[rmiao]

Tried on my sql2k and sql2k5, can't reproduce the problem. What did you do step by step?

[Picha Pie]

Did the import wizard. Chose the datasource & destination using Microsoft OLE DB Provider for SQL Server(also tried Excel & Access). Selected the Source tables(didn't need to do mapping because its the same table) then just executed it.

[rmiao]

Tried with sql native client? That worked for me.