calling all SSIS developers

[Renault]

ivvala oka intervw lo this q'nn asked? annswer plzz.

how to load multiple files  parallelly using only1 data flow task ?

 

[1Nenokkadine]

help

[sri_sql]

5 minutes ago, Renault said:

ivvala oka intervw lo this q'nn asked? annswer plzz.

how to load multiple files  parallelly using only1 data flow task ?

 

Using multicast 

[Renault]

21 minutes ago, sri_sql said:

Using multicast 

how man...multicast is for copying same data to multiple outputs kada...

[Renault]

ltt

[cheenu]

Merge Join Cheyochu Man....cascading chesthu cheyochu any number of sources, because you can only merge 2 sources at a time... but parallel ga load avvadu it merges and then loads

 

[Renault]

14 minutes ago, cheenu said:

Merge Join Cheyochu Man....cascading chesthu cheyochu any number of sources, because you can only merge 2 sources at a time... but parallel ga load avvadu it merges and then loads

 

parallel ga seyadam not possible aa aithe with only 1 data flow?

[loveindia]

1 hour ago, sri_sql said:

Using multicast 

champestaavaa man pillodini...

[loveindia]

39 minutes ago, cheenu said:

Merge Join Cheyochu Man....cascading chesthu cheyochu any number of sources, because you can only merge 2 sources at a time... but parallel ga load avvadu it merges and then loads

 

merge join with cascading aaa... what is this cascading man... you mean nesting???

[loveindia]

The answer for this is using "Multi Flat File" Connector instead of "Flat File" Connector... That will process all files in one DFT and load parallelly at one time man...

[cheenu]

1 minute ago, loveindia said:

merge join with cascading aaa... what is this cascading man... you mean nesting???

yeah...man

[cheenu]

11 minutes ago, loveindia said:

The answer for this is using "Multi Flat File" Connector instead of "Flat File" Connector... That will process all files in one DFT and load parallelly at one time man...

+1

[Renault]

20 minutes ago, loveindia said:

The answer for this is using "Multi Flat File" Connector instead of "Flat File" Connector... That will process all files in one DFT and load parallelly at one time man...

nee kosame waiting man,,,,multi flat file connector ssis lo unda man..or vere third party tool use seyyala?

[Renault]

25 minutes ago, loveindia said:

The answer for this is using "Multi Flat File" Connector instead of "Flat File" Connector... That will process all files in one DFT and load parallelly at one time man...

then how todo multiple tables in the same way man?

[Quickgun_murugan]

4 minutes ago, Renault said:

nee kosame waiting man,,,,multi flat file connector ssis lo unda man..or vere third party tool use seyyala?

Hint ichadu ga ... Google chesko details kosam...