Hello:

I have one table that for each row I have to insert various record in
several table, and I want to in dts. This is example

table1
-field1
-field2
-field3

I would like for each record or row of this table:

insert table2 somevalue, field1, field2
insert table3 field1, field3
insert table4 newguid, field2
and so on

Best regards,
Owen.

Personally I would be looking to move the data in > 1 data pump task.
For each table into which you need to pump data you have separate data
pump.

Allan

"Owen" <anibal (AT) prensa-latina (DOT) cu> wrote

Sure


Define your fisrt data pump between the source and destination. Now
using a workflow constraint do the same fo the second data pump task so
you will chain them together


Source --> Dest -- ON SUCCESS -- Source2 --> Dest2 etc


Make sense or is there something I am missing?

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)



Allan


"Owen" <anibal (AT) prensa-latina (DOT) cu> wrote

You are not going to be doing anything Row * Row here.
Yes I mean the Data transformation task.

As far as I see you want to move certin columns from each row to
different tables. You will use for each Data Pump a SELECT statement
that only picks up the correct columns needed.

How are you going to generate a new guid?

In the destination can you not have a default on the columns that
generates one using newID()?


Allan


"Owen" <anibal (AT) prensa-latina (DOT) cu> wrote

Hello:

Please can you give some example that how can I do that? MS SQL Server 2000

Best regards,
Owen.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello:

when you talk about data pump, do you mean trasformation task? and this
workflow can work for each row, because I read you articule recommended and
this said that the Task A must complete successfully, all task?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello:

I forget ask this too, in the case that I have to insert new guid, how can I
do that?

Best regards ans sorry for be so "impertinente"
Owen.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote