Deja vu

fiscal cliff

Try making the variable an object type. Although you are really only returning a single value, the task views it as a set that might contain more than one...

Pie!!

-Create a variable to hold your return value.

-Change your ResultSet: None to SingleRow

-Map your variable to your result set

Usually I go back to the original query at that point and resolve the issue there.

If you have some sort of ID column, use a lookup transform to lookup data that is already in your table and match it to the data coming in from...

=JOIN(Parameters!ParameterName.Value,", ")

Are you using a stored procedure? Maybe it has more parameter inputs than you are sending.

status quo

Brandie Tarvin (11/7/2012)

---

Lee Crain (11/6/2012)

---

I just ran across this one; I can't help but post it. This list is just part of the total job requirements:

Knowledge, Skills, and Abilities

- In...

R2 must have a parameter that you feed with the variable value from R1.

Set up your parameter in R2. Build R2 so that it will run when given the...

Vote

If my other suggestion doesn't work you could also create 2 target files tasks and use a conditional split that would channel the data to the correct output format.

I don't remember if this in 2005 or not, but in the connection properties there is a delimiter value that can be set by an expression. Right click on...