I am a new user on SQL DTS. I normally transfer the data from informix to SQL2K using the DTS import and export wizard. I have a few related tables in source DB(informix). I would like to perform a per record transfer on those related tables to another database. Meaning that after transfering 1 record with primary key=100 from parents table to destination DB(SQL2K), then select all records from child table in informix where primary key = 100 and transfer them to SQL2K. then continue the same procedure for the subsequence table. Is DTS able to perform that? if yes how can i do that? Help is needed urgently.

Yes, it can be done. You could use a join to get all you records in one go, put the results into a temporary table in the SQL Server DB and then run a stored procedure to extract the relevant records and put them into the correct tables, or maybe use a combination of ADO and Transact-SQL.

--

Joe