RBarryYoung (1/15/2009)

---

Jeff Moden (1/15/2009)

---

That's another good one. And, I've never seen it where they need to return an out of scope identity produced by @@IDENTITY... anyone ever actually do...

I have never had to do this, and can't for the life of me see an occasion where I would want to.

Which begs the question, why didn't they make the...

the one I've seen a lot is the use of @@IDENTITY rather than SCOPE_IDENTITY(), when retrieving the id of a newly inserted row

Not that @@IDENTITY would necessarily be wrong, but...

Thanks Mukti

That does seem the way to go for new SSIS packages... however I was hoping to find a way to retorspectively change the ones we currently have, without having...

Okay, I think I've figured out why I was confused.

As I understood it, if the Expression evaluates to TRUE, the next task will run

If it evaluates to FALSE, the next...

dyana,

I'm sorry, but I'm not sure I understand what you mean.

Task1 will not fail - it either populates an output parameter with '' or with some other text.

Are you suggesting...

Phil,

Interesting, Task2 does not run when @Variable=="" is the expression (and the output param is indeed an empty string, so one would expect the task to run)

I guess this is...

hi dyana,

Thanks for your response.

The output variable will either be an empty string, or will actually contain some text. This text will be used further down the line in the...