In your data set definition > 
Something like this will help get you going : This just to illustrate the concept. I am using an older version of the adventure...

I suppose that doing this in the following fashion

DECLARE @commandText VARCHAR(8000)=''
SELECT @commandText = @commandText +char(10) +char(13)+
   'EXEC master.sys.sp_addmessage @msgnum = ' + CAST(message_id+10...

Just to cross this item out, you are sure that your 'O' is not a'0' instead?

Thanks!

In my dimDate table I like to have a DATE type to represent the weekStart, monthStart, quarterStart, etc...

With this design in place I can easily handle such a...

Can you see my previous post and let me know if this is what you are trying to do? It appears you are, and from what I see you are...

Referring to figures 7 and 8 ... I also wonder what someone would expect from the use of the NOLOCK operator. It is not an optimizing technique.

I definitely think there is a language barrier here as I am still hung up on 

Is the CTE able to make use of an appropriate index in this case? I am guessing yes...

I cant imagine 70 databases/iterations would be a burden on a cursor. 
I have not tested this but something looking like >

use master
go

Not sure that you need a dynamic sql statement in Ole db source adapter, via a variable. To use something like a date variable I can simply construct my query...

Try 

CREATE TABLE #CuriousCaseOfSum(val DECIMAL(18,1) NOT NULL)

INSERT INTO #CuriousCaseOfSum(val)
VALUES (1),(2),(3)

DECLARE @var DECIMAL(12,0)=12.6
    SELECT    @var, Sum(val) , @var+SUM(val)
    FROM    #CuriousCaseOfSum

DROP TABLE...

The data element named “date_key” is absurd; a date is a unit of temporal measurement in a key is how a data element is used in a particular...

Take a good look at your...