SSIS Related Question

[Tech_Babu]

Hi I have multiple tables(table a, Table b, table c) in Sql Server Database A and i need to move data to another Sql server Database B (table 1, table 2, Table 3)

Table A (in source is similar to table 1 in Destination but not exactly the same ) some columns from source are not required and data type is slightly different. etc.

similarly other tables. will i have to create a seperate dataflow task for each table? or can i use the Foreach SMO if i use Foreach smo will i be able to apply some transformations depending on each table.

 

Thanks

[crazymatta]

ltt 

[Buttertheif]

3 minutes ago, crazymatta said:

ltt 

 

[thisisme]

You do not need for each here....Take one data flow task, drag data flow source, connect it to data flow destination and map only the columns you need from table a to table 1. Do it for the remaining tables. You may take a separate data flow task for each table or you can also put all 3 table transfers n the same task. Depends on how you want to design the package.

[kothibava]

2 minutes ago, thisisme said:

You do not need for each here....Take one data flow task, drag data flow source, connect it to data flow destination and map only the columns you need from table a to table 1. Do it for the remaining tables. You may take a separate data flow task for each table or you can also put all 3 table transfers n the same task. Depends on how you want to design the package.

[Tech_Babu]

 

thanks bhayya

[libraguy863]

On 9/9/2016 at 5:51 PM, thisisme said:

You do not need for each here....Take one data flow task, drag data flow source, connect it to data flow destination and map only the columns you need from table a to table 1. Do it for the remaining tables. You may take a separate data flow task for each table or you can also put all 3 table transfers n the same task. Depends on how you want to design the package.

[kick_seenu]

3 tables ki for each deniki?

okati tarvatha okati ante 3 seperate data flow task pettu

parallel ga ante 3 oke dantlo add chei

[Tech_Babu]

3 tables is just an example i have about 25 tables

 

[mtkr]

SMO use chesthe i guess Xfermatns use cheyyalevv.. dependent to table...

kwalling experts...