Im using the Tasks/Import wizard in Management Studio for a 2005 MSSQL to import a table from another database, same MSSQL server
on my machine im having: mssql 2000 (default instance), mssql 2005. 2000 is not running, only 2005.
(by the way: all .net tools like Management Studio, Database explorer in VS 2005 and so on NEVER find the 2005 instance in the combo for available servers ! i always have to enter it manually)
I am always getting:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found.
({3A6A6A25-FF8B-4E17-B2A9-C0181A291B5D})
I tried all scenarios:
different databases / tables in same server / different servers, 1 talbe, many....
it always stops there !
What do I have to do ? It is impossible to work like that !
thanks in advance, Michael
Is microsoft going to answer this? I have seen many posts like this but no solution?|||They finally did after some month! in another thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255347&SiteID=1
see: http://support.microsoft.com/kb/913817
hope this helps, good luck
Michael
