0

I use SSIS with SQL Server 2016. I need to know which below approach is better.

In one of my DataFlow task, I need to add more than 100 Derived columns. Should I add just one Derived Column component with 100 new expressions or should I add several Derived Column component in rows?

This is the first option:

enter image description here

And this is second option:

enter image description here

enter image description here

Which one is better?

Hadi
  • 36,233
  • 13
  • 65
  • 124
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
  • @ArdalamShahgholi have u tried both methods? is there a difference between execution times? – Hadi Apr 23 '17 at 20:21
  • if you tried both methods, plz provide execution times – Yahfoufi Apr 24 '17 at 12:12
  • 1
    I am in begin of my project, I don't have the real data yet. I have asked this question because I don't want have the problem in future. – Ardalan Shahgholi Apr 24 '17 at 15:07
  • @ArdalanShahgholi if derived columns are independents you don't need to create multiples. i don't think you will find something else. i tried 2 methods they had Almost the same performance (one component is better) – Yahfoufi May 04 '17 at 13:16

2 Answers2

1

There is no need to create multiple derived column component if derived columns are independents, else you should create multiple components.

Also every added component inside the dataflow task has it's own properties that need validation. so i think it is better to minimize the number of components if it is doing the same thing.

Recently, I published a detailed article on this topic:

Hadi
  • 36,233
  • 13
  • 65
  • 124
0

You can add different expressions for multiple columns in one derived column transformation task. There is no need of adding multiple derived column.

Kapil
  • 987
  • 5
  • 11