chrisn-585491 (8/15/2013)

---

Cuban is a real hard worker and smart, but he also had the luck of being at the right place in time to capitalize on his fortunes and make...

wolfkillj (8/14/2013)

---

Somewhat OT, I'm old enough to remember using a high-speed Kodak electrophotographic copier with a fancy finishing unit attached. The whole thing was about 20 feet long, and, like...

This conundrum has always been one of my favorites. Apply the patches to keep your systems secure but potentially break something, or leave yourself vulnerable while testing patches (or...

CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.

Seems there's a little confusion (or else I'm confused).

As I understand it, checkpoint file usage is set in the Control Flow Properties sheet. Then you set the FailPackageOnFailure to...

I'll admit I'm mostly ambivalent about the newsletter change, though I prefer the older version only because it was easier on the old eyeballs.

And I must admit I'm not all...

I'll add one that's so obvious it's easy to miss:

PLAY

Speaking as one who is living proof you can learn and improve SQL Server skills on the cheap, one of my...

SSIS does have DATEADD(), DATEDIFF(), and DATEPART() as well as...

In view of the coming big data/data analytics wave, I'm working my way through a book on calculus. I took an online Statistics class sponsored by Univ of Toronto...

My boss related a story about some software he was troubleshooting in a call center. I don't recall if he developed it, but every so often the entire system...

Be it article or editorial, it's still a good summarization of the "third wave" so to speak of the database world. Right now the role of the data scientist...

If you check BOL, the OnPostExecute event fires after an executable finshes running. An error causes an executable to finish running.

2103? Lowell: You're ahead of your time. 🙂

Also, it should be DATEPART(hh,PIT) <> 12 in the second part of the WHERE condition.

You could use a Script Task to check for a valid connection before your Data Flow and then take different actions depending on the result. For example a Success...

I was thinking SSDT, too.

Software updates in general seem to be driven more by marketing and perception than anything else, and don't EVEN get me started on version numbers. ...