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

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" <member39115@dbforums.com> wrote in message
news:3357162.1063280440@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