This definitely qualifies for SQL Spackle!

.....and this is why I am NOT a DBA by trade....

0 points for me.

Chance of Phillies vs Yankees in the World Series = Chances of SQL Server team creating a full-featured Business Intelligence Metadata Integration Tool in this decade.

Better the Yanks than the Phils. No way in hell do I spend that much for 0 games in MLB.

No problem.

There are also other schools of thought in data warehousing as well. You can check out Bill Inmon's site(s) as well with respect to the Corporate Information Factory.

If I am MS, I would also like to appeal to as many customers as possible 😀

The heart and soul of an ETL tool is the ability to connect to...

You can use the datepart function. For example:

select DATEPART(hh, '2014-01-21 19:26:17.523') will return 19.

For hours, mins, and seconds you can use:

select convert(time(0), '2014-01-21 19:26:17.523')

One final thought: Will you need to be doing a lot of cross-product analysis, or will they mostly be Line Of Business or Product Type specific?

I would go with whatever is easier for the customer to query and possibly for you to abstract for the customer--although it is always tempting to go with developer convenience....

This is a must have for anyone trying to create a T-SQL dominant ETL solution. Command logging is an absolute must. Good stuff, Dwain.

If you combine this solution with the...

Interesting approach. I am too lazy. I just go to either the kimballgroup's website or Don McMunn's site...........then extend as necessary. 😀

I wish there were more split screen views in a baseball game so that folks that did not play baseball after the Babe Ruth league level get to see just...

I love SSIS, but I can see why others do not. The biggest complaints I hear are from folks that are not primarily in Business Intelligence....

Nice question.

Sidebar:

I love HASHBYTES for detecting EXACT duplicates in certain situations where there are lots of columns. Lots of folks try CHECKSUM first.....only to be disappointed in the end. It...

In my last two situations we had an intense data quality/validation schema and dedicated data stewards (rare, I know).

The compromise would be, as you stated, to disable a...