473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Relational Data Transfer in DTS


Hi Please help for this simple problem

DTS Transfer or any other method?

I have Customer_Order Table and customer_Order_Details Table.

For OrderID = 1, I have 3 rows of Order Details.I want to transfer
Customer_Order Table for OrderID 1 in DTS, the system should transfer
Order Table as well as Order details table Rows for ORderID =1.

How to customize in DT or is there any way to get this data to transfer
from source DB to Dest DB?

KAMAL KUMAR V
--
Posted via http://dbforums.com
Jul 20 '05 #1
1 2162
You should be able to do this easily. Set two transfers and use a query for
your data source instead of a table or view.

Start designing a new package. Create a source connection and a destination
connection. Then click the source, control-click the destination and then
click on the 'transformation' icon from the task icons on the left.

Right-click on the transformation arrow and select "properties." The first
tabbed dialog is "Source" change the type to a "sql query" and enter the
text of a query that will select just the rows you want in the text box.

You can use the "preview" button to see the first few rows from your new
source query.

Then you specify the destination and transformations in the usual way.

"kamalkumar" <me*********@dbforums.com> wrote in message
news:33****************@dbforums.com...

Hi Please help for this simple problem
DTS Transfer or any other method?
I have Customer_Order Table and customer_Order_Details Table.
For OrderID = 1, I have 3 rows of Order Details.I want to transfer
Customer_Order Table for OrderID 1 in DTS, the system should transfer
Order Table as well as Order details table Rows for ORderID =1.

How to customize in DT or is there any way to get this data to transfer
from source DB to Dest DB?

KAMAL KUMAR V
Posted via http://dbforums.com

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Stylus Studio | last post by:
DataDirect XQuery(TM) is the First Embeddable Component for XQuery That is Modeled after the XQuery API for Java(TM) (XQJ) BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies...
1
by: Tim Fierro | last post by:
Hello, I have had many years using flat file databases (File Express from way back) but am now at a company where a relational database is needed and would carry us into the future. Since I...
1
by: A. Nonym | last post by:
Hi, everyone! in the lab couse this semester we are asked to transfer a big xml file (more than 300MB) with DTD into a relational database. Any ideas how we can do it effenciently? Thank you and...
7
by: Pradeep | last post by:
Hello, I need to take a set of input tables and create an XML output file. The format of the XML output must be user-definable and must be intuitive enough for non-techies to use. input...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.