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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-28 : 09:57:07
|
| Jason writes "Hi,I have a clustered SQL 2005 server (say Server SQL) which is using SSIS to consolidate data from our ERP system.The ERP system uses a Pervasive database and all the data is currently stored on a another server on the network (say Server PVSW). I need to make a connection from Server SQL to Server PVSW to be able to import the data.What would be the best way to do this? I want to install a Pervasive client on Server SQL which will enable me to use a std ODBC connection to either create a linked server, or just use a direct import of the data I require.Some say that this will cause issues with the cluster service running, but if the client is installed on all nodes, surely that wont be a problem?Cant' find much documentation on this so....well...I'm stumped! :)" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-29 : 06:21:13
|
| If it's on the same network just use DTS to import the data, register the Server in EM and go for it, you don't need to set up a linked server at all.. I can't see how this will affect the cluster if all you want to do is import data into an existing DB.. |
 |
|
|
|
|
|
Remote Connection