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 |
|
frlep
Starting Member
4 Posts |
 Posted - 2008-03-04 : 09:00:05
|
| Hello,I hope somebody can help me.We have two servers , the first one uses MS SQL 2000 and the second one uses MS SQL 2005. Both servers contain the same databases.I need to create a data transform services (DTS) to export every day some databases. I can create it, but when I launch it ,I receive a error message : [SQL-DMO], you must use 2005 Management Tools to connect to the server.Thanks for your helpHope to hear soonFrlep |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-04 : 09:04:30
|
| You need to use SMO objects for handling SQL Server 2005 objects. DMO is only supported through a special backward compatibility redistributable.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-03-04 : 09:29:35
|
DTS became SSIS in 2005. SSIS supports both 2000 and 2005 so you could use that.
elsasoft.org |
|
|
|
frlep
Starting Member
4 Posts |
Posted - 2008-03-04 : 09:58:59
|
| Thanks for your prompt replies.I have tested the BC package , but it doesn't work correctly , I have still the error message.But when I create a SSIS package to transfer objects from SQL 2005 to SQL 2000 , it works correctly.kinds regards |
|
|
|
|
|
|
Error "SQL-DMO" You must use 2005 management tool