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.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2007-09-18 : 17:41:32
|
| Hi, all,I did not see this one coming, and I am not sure if I did something wrong.How do you push data from sql05 to sql2k?I set up a data flow task, with one sql05 connection magager and another sql2k connection manager. Then when I tried to map them, I cann't!The message on the box said: The connection manager uses an earlier version of sql server provider. Bulk insert operations require a connection that uses a sql server 2005 provider.I have been trying different source, destination and transformation, but seems like missing something.Thanks! |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-18 : 19:05:26
|
| Make sure you have the latest service packs on sql2k and sql2k5.setup a linked server from 2005 to 2000. example:EXEC sp_addlinkedserver@server = N'ALIASFORLINKEDSERVER',@srvproduct = N'',@provider = N'SQLNCLI',@provstr = N'SERVER=SQL2000IPADDRESSORDNS;Integrated Security=True'select * from openquery(ALIASFORLINKEDSERVER,'select * from database_catalog.schema_user.table_object')orselect * from aliasforlinkedserver.database_catalog.schema_user.table_object |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-18 : 20:13:33
|
| For SQL 2005 to SQL 2000 data transfers I use "OLE DB Destination", instead of "SQL Server Destination" and it works. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-09-18 : 22:22:24
|
| Ole db destination did the trick. I will try linked server later.Thanks for both of you! |
|
|
|
|
|
|
Push data into sql2K