First of all, i want to give a brief overview what im trying to do.
We have 2 servers AS/400 and SQL, our AS/400 capacity is already reached it's limit (but our SQL server still have large capacities), so my supervisor ask me to 'remove' old-and-rarely-used data from as/400 to SQL so it will free up some space in AS/400.
So the scenario is, first we will determine the criteria of the old-and-rarely-used data, and transfer the data by job (that run DTS) overnight, we will run this job for certain period (once a day/week/month).
In daily basis (we use AS/400), if we searched for particular data and unable to find it in AS/400, we will search in SQL and transfer the data back to AS/400 (approximately, max 1000-2000 rows, 60 columns each).
What i want to ask is, which one better to transfer data back from SQL to AS/400, DTS or Linked Server (use openquery) or there's any better way? My concern is the transfer speed, we need to transfer the old-and-rarely-used data as soon as possible.
PS: I'm using SQL Server 2000
Thanks a lot for your attention,