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 |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2006-03-22 : 18:41:44
|
| We have a server that houses a sql server db. Let's call this server server1. Then we have another server, let's call it server2. This server houses dbf file.We need to schedule weekly data export from sql server db on server1 to dbf file on server2.I am completely stomped on this. Does anyone have any idea???thanks much in advance |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-22 : 18:46:05
|
| U can do it by a DTS Package.Create a DTS and Schedule it. |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2006-03-22 : 22:06:14
|
| Srinika,Thanks for you response.I know how to use dts package but we are talking about 2 different servers.And one db is sql server; the other is dbf file. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-22 : 22:07:39
|
| search for linked serversHTH--------------------keeping it simple... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-23 : 01:52:53
|
| Also look for OpenRowset, OpenDataSourceMadhivananFailing to plan is Planning to fail |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-23 : 08:15:04
|
quote:
Originally posted by simflex
Srinika,I know how to use dts package but we are talking about 2 different servers.
What do u mean by the above? if u know well, u can go ahead and do it  unlessIs there any restriction of using DTS when Source & Destination r in 2 diff servers ?[ U may need to Link the 2 servers - sp_addlinkedserver ]orIs there any restriction of using DTS when Source or Destination being a dbf file ?in which caseu may tell what it is  |
|
|
|
|
|
|
exporting data from one db into another...