Good question. I did not see in the documented link the mention of table variables. Did I miss something?
Thanks

Wrox the publisher has a good book on SSIS that I read some time back. I'm sure they have updated versions on the subject and that would make good reading. 

You can have a extended property that serves as a URL to a Sharepoint site or other shared resource with the actual columns documentation. Hence you at least here create...

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...