I consider my audience when I'm doing documentation and/or instructions.

If the audience is outside of the technology field then I assume they know nothing and start from the...

I do most of my work as ELT so that I can leverage the servers and the flexibility of TSQL as needed.

There are times when it isn't practical...

The reason you're not seeing your padding and Phil's code will work is that the date functions return integers. Prepending a zero to an integer does nothing for the output.

I used to handle all the software licenses for a decently large company - in my spare time. These were Microsoft, IBM, Adobe, and Veritas mostly so they were large...

So I was trying to find some values in Hadoop using Impala to find out why SSIS wasn't accepting the input. Fine. Whatever. Different database systems, etc.

Trying to...

First - why don't you want to stage the data? That's a very common practice and a good filter to make sure your data is as you expect it to...

SSIS (at least through 2012) doesn't recognize DATETIME2 when assigning a value to a DATE variable. It has to be cast to a DATETIME data type.

This has been...

First off I'm leery of your 'select top' methodology since it seems to lend itself to uncertainty. But beyond that.

The row count variable should be defined to at...

This may sound obvious but are you running the package or selecting and running a task? This makes a difference because you only get breakpoints when you run the entire...