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 |
|
Frozen_123
Starting Member
33 Posts |
 Posted - 2007-11-15 : 23:01:26
|
| Hi All,I want to transfer some of data from one instance to another instance at 0000 hrs every day. I have sth in my mind about this issue but its not as per bussiness logic explaned below.If I create a DTS package which will export filtered data to .xls file from one instance and import the data of .xls file to another instance. Then I can schedule the DTS package. Suppose I am using XYZ table in both instance.Could anyone have better solution.Regards,Frozen |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-15 : 23:05:06
|
why do you need to go through excel file ? with DTS, you can copy from a table to another.Alternatively you can also use link server to do it.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Frozen_123
Starting Member
33 Posts |
Posted - 2007-11-17 : 01:10:15
|
| Thanks Khtan |
|
|
|
|
|
|
DTS