Apologies for the late reply:

SELECT DISTINCT d.DaysInCalendarMonth

FROM dbo.dwCalendars d

WHERE d.CalendarYear = 2011

AND d.CalendarMonthName = 'February'

Of course, if you use a calendars table you never have to worry about having to code or validate any date calculations ever again. 😛 Sure makes life a...

I find Multi-Edit very useful because you can copy/paste/delete columns as opposed to just rows. I'm sure there are other tools that do this as well. I find...

Great article, Cliff!

I would recommend building a date dimension table for this kind of thing. Add columns for everything you might want to know about each date....

Bad Advice

Yes, I agree that most of the time people have good intentions and don't intentionally give bad advice. It harkens back to a favorite quote of mine -

"It's...

Nicely written article, Jeff! I'm new to this forum so don't know if you've covered it already, but it might be nice to see a counterpart to this article,...

Here is what worked for me -

* Delete the Flat File Destination and the Flat File Connection Manager.

* Create a file with the column headings you want in the order...