Nice question, did a little research on this to get it right, though I did do a double-read-and-analyze.

Saludos,

Hello, People!!!

Just to let you know, because of a deadline constraint I had to translate the functionality of the SSIS package to T-SQL, which was faster than trying...

Happy new year, everyone!!

I just wanted to break the almost-1-day-no-activity on the thread.

Saludos,

Thanks a lot for your reply, Brandie.

Brandie Tarvin (12/27/2012)

---

EL Jerry (12/26/2012)

---

Thank you for your response, Greg.

Greg Edwards-268690 (12/26/2012)

---

If being run as a SQL Agent Job, you should be able to...

Thank you for your response, Greg.

Greg Edwards-268690 (12/26/2012)

---

If being run as a SQL Agent Job, you should be able to track down if it is in MSDB or being run...

Thank you for your reply, Stefan.

The package is being executed in a...

Hi all!!!

I hope everybody had a very Merry Christmas.

Can someone with more experience on SSIS provide some guidance here?

I will thank you so much.

Saludos,

Congratulations, Lynn, on your 2012 SSCFFL championship.

Whoever organizes the 2013 FFL, make sure you count me in.

Saludos,

Good question. Honestly I hadn't cared much about SUMs including NULLs. Great to know this.

Saludos,

I hope everybody had a very Merry Christmas, and I wish all of you a very happy new year 2013.

Saludos,

Thanks for the easy question.

Saludos,

Confusion led to testing, which in turn led to guessing.

The wording of today's QotD is very confusing, and trying to RENAME a PROC using ALTER led to error, which left...

Thank you for the easy question.

Saludos,

I picked the right answer because I did think the semicolon was a typo from Ron.

Great question about options, but keep in mind that naming DB objects with reserved words...

I set up a test script and ran it, and to my surprise got the right answer based on the script outcome.

I was surprised of the results.

Excellent question, Tom!! ...