Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 1st, 2004, 10:20 PM
Registered User
Join Date: Mar 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default transformation on set of related tables?

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.
Old March 3rd, 2004, 12:21 PM
joefawcett's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts

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.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting related tables to excel crisan Access 10 July 24th, 2012 04:23 PM
related to look up transformation. pravasis SQL Server 2005 1 July 9th, 2007 11:06 PM
Synchronising Two Sets of Related Tables Odeh Naber Access 11 May 14th, 2007 06:58 AM
Insert record Into 2 related tables at once kalchev ASP.NET 2.0 Basics 2 May 9th, 2006 05:10 AM
Insert on 2 Related tables question acdsky Classic ASP Databases 1 July 21st, 2004 09:29 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.