After the conditional split and the multicast you have 4 different paths.

Add a derived column to each path.

In the derived column, you simply add a new column and put the...

What do you do inside the package?

Your data conversion component doesn't actually convert the column itself to another data type. It makes a copy and stores the converted data in that new column.

That's why you have...

I kept thinking about this scenario, and you can also implement it without a script, using only SSIS components.

Put a conditional split that checks the location. You have 3 outputs:...

The easiest way woul be to use a script component as a transformation.

Use a switch statement on the location column to determine the locationID.

If it is "common", you need to...

Didn't even have to think for this one (which makes it an excellent Monday question)! 😀

Grant Fritchey (7/19/2013)

---

Sean Lange (7/19/2013)

---

We have from time to time started heading in a bad direction. The good news is that there always seems to be a few people around...

Grant Fritchey (7/19/2013)

---

I was doing some research this morning and got sucked down a rabbit hole (it happens) and landed on a series of sites complaining about Stack Overflow and...

Rich Weissler (7/19/2013)

---

This question will be fun for the poor soul who attempts to answer the question in 2017 and tries to guess what might have been considered 'current' way...

Change it in the designer. Before saving it, hit the "Generate change script" button.

george sibbald (7/19/2013)

---

renamed to SSDTBI to avoid confusion! could have fooled me.

So with SQL2012 and 2014 install media we dont get the option to install the BIDS equivalent? that sounds...

Apparently not:

http://www.bidn.com/forums/microsoft-business-intelligence/reporting-services/190/can-we-hide-the-parameter-based-on-the-value-of-another-parameter

Michael Riemer (7/19/2013)

---

+1

Don't understand the logic of the insistance on renaming something that everyone is happy...

That's oversimplifying 😀 SSDTBI (the one for Visual Studio...

This is a good article on how to concat row values:

Concatenating Row Values in Transact-SQL[/url]