CODEWITHSUNDEEP
sql-serverssis
Kustomize
Kustomize

Reputation: 39

SSIS multiple sources to a single derived column

Is it possible to have multiple sources (OLE DB) to go through the same derived column and the like? My current setup is have multiple control flows with same derived columns/splits/sorts etc. which output to the same destination but the only difference is the source. It is difficult to modify these derived columns as I have to do it a few times (5) which may lead to mistakes.

One solution I have explored previously was to use dynamic sql so I can use 1 source and multiple variables, but given the complexity of my queries I'd rather avoid this.

Upvotes: 1

Views: 637

Answers (1)

Nick.Mc
Nick.Mc

Reputation: 19184

I suggest you use the UNION ALL component. If all your data sources have the same fields and data types, then feed them into a union all component then apply the column transformations to the output.

https://learn.microsoft.com/en-us/sql/integration-services/data-flow/transformations/union-all-transformation

Upvotes: 3

Related Questions