I am sorry...

I am using a stored procedure built by another developer to provide data in above post.

IF @Department in ('1,5') --Grocery

BEGIN

SELECT (m2.Sales_2012/1000) as Sales_2012

,(m4.Grocery/1000) as 'Plan'

,m3.fiscal_week_2013

,(m3.Sales_2013/1000) as Sales_2013

,(m3.Sales_2013/m2.Sales_2012)-1...

I read the article about Incremental Data Loading using CDC - but can you create an article and demo step by step on how to capture changes from a bulk...

Can someone help with this question?

I need to identify the source db when I am inside the Data Flow

I have a merge join task that joins two server tables together after being sorted, ...