November 15, 2007 at 9:03 pm
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,
Austin
November 16, 2007 at 2:15 am
Create a DTS package which just transfers the data directly from table to table.
November 16, 2007 at 3:08 am
Right click on the required table on the source server -- > all taks -->Export data - > follow the wizard steps --> set the source and destination tables -- > at the end save the same wizard steps as DTS package and then schedule the package according to your required timings.
arj
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply