Dear All, In the series of zero to hero SSIS series this is one of the simplest transformation control which known as UNION ALL. As you might aware UNION in general term which means collective. In SSIS UNION all control is doing the same task. It collect all the inputs may be of same …
It is very interesting how to insert multiple values with a single statement. Lets understand this with the help of below example. Suppose you have a Country table and you want to insert seed (initial values) then you can write those statement like below Now same values can be inserted with another one …