By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,725 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,725 IT Pros & Developers. It's quick & easy.

Relational Data Transfer in DTS

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.