I had an 'analyst' once who would create dozens of temp tables with huge amounts of data in them, never drop them, and leave his sessions open for days. ...

I would have specified that the default schema is 'dbo' just to be clear, but I suppose without an indication of the default schema you would have to assume the...

Toreador (12/6/2012)

---

That's exactly the conversation I had with myself. Was this a trick question or not? In the end I went...

Very interesting question... definitely not something I would have realized otherwise.

Yep, me too. Sad I didn't get the point, but I...

You can use a ForEach Loop task to read from a recordset object and assign the column values from each row to a variable.

Interesting question. I did run into this function once before when looking for a simple way to parse a short delimited string. Unfortunately my string had five elements....

Interesting question.

Thank you for the detailed explaination Hugo.

BTW, I'd just like to add that I think calling an SSIS package from an insert trigger is a very bad idea. :unsure:

If it works fine when the trigger calls a job that calls the package, then I would bet it is an issue with the account being used to run the...

In the database you are working in, you can create a synonym for each table you want to access outside of the account's database you are working in.

I...

Hmm, that's a pretty good point actually....

Nice question!

I would have gotten this wrong without some research. The name seems counter-intuitive, doesn't it?

Very interesting, thanks for the question!

Hugo Kornelis (10/5/2012)

---

I *knew* when I saw the answer options that there would be a possible source of confusion here.

Yes, the insert into the second table will fail. But that...