|
|
You're in the
sql server dts
group:insert in various table for every row
sql server dts:
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.
Hello:
Please can you give some example that how can I do that? MS SQL Server 2000 Best regards, Owen. [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:u6EsKQT8FHA.3504@TK2MSFTNGP11.phx.gbl... > 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@prensa-latina.cu> wrote in message > news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > > > 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. >
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? [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:uvREG9T8FHA.2576@TK2MSFTNGP12.phx.gbl... > 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@prensa-latina.cu> wrote in message > news:uKVu93T8FHA.132@TK2MSFTNGP15.phx.gbl: > > > Hello: > > > > Please can you give some example that how can I do that? MS SQL Server > > 2000 > > > > Best regards, > > Owen. > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > news:u6EsKQT8FHA.3504@TK2MSFTNGP11.phx.gbl... > > > > > 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@prensa-latina.cu> wrote in message > > > news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > > > > > > > > > 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. > > > > > >
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. [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:uvREG9T8FHA.2576@TK2MSFTNGP12.phx.gbl... > 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@prensa-latina.cu> wrote in message > news:uKVu93T8FHA.132@TK2MSFTNGP15.phx.gbl: > > > Hello: > > > > Please can you give some example that how can I do that? MS SQL Server > > 2000 > > > > Best regards, > > Owen. > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > news:u6EsKQT8FHA.3504@TK2MSFTNGP11.phx.gbl... > > > > > 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@prensa-latina.cu> wrote in message > > > news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > > > > > > > > > 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 [quoted text, click to view] "Owen" <anibal@prensa-latina.cu> wrote in message
news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > 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.
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 [quoted text, click to view] "Owen" <anibal@prensa-latina.cu> wrote in message
news:uKVu93T8FHA.132@TK2MSFTNGP15.phx.gbl: > Hello: > > Please can you give some example that how can I do that? MS SQL Server > 2000 > > Best regards, > Owen. > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:u6EsKQT8FHA.3504@TK2MSFTNGP11.phx.gbl... > > > 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@prensa-latina.cu> wrote in message > > news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > > > > > > 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. > > >
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 [quoted text, click to view] "Owen" <anibal@prensa-latina.cu> wrote in message
news:uo7K2NU8FHA.2036@TK2MSFTNGP14.phx.gbl: > 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@no-spam.sqldts.com> wrote in message > news:uvREG9T8FHA.2576@TK2MSFTNGP12.phx.gbl... > > > 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@prensa-latina.cu> wrote in message > > news:uKVu93T8FHA.132@TK2MSFTNGP15.phx.gbl: > > > > > > Hello: > > > > > > Please can you give some example that how can I do that? MS SQL > Server > > > 2000 > > > > > > Best regards, > > > Owen. > > > > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > > > news:u6EsKQT8FHA.3504@TK2MSFTNGP11.phx.gbl... > > > > > > > > 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@prensa-latina.cu> wrote in message > > > > news:u$EH9CR8FHA.3224@TK2MSFTNGP09.phx.gbl: > > > > > > > > > > > > > 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. > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |