Try getting the variance at the query level.

Also, I tried using OLE DB Microsoft Jet 4.0 Provider connection to the CSV files folder with an OLE DB Source.

One strange problem i see here is,

The 2nd CSV file...

CREATE TABLE Test(

ColA [varchar](500) NULL,

ColB [nvarchar](500) NULL,

.

.

ColK [nvarchar](500) NULL,

)

I am getting NULL records inserted...

no it is nvarchar..

Thanks for your suggestions.

One thing i would like to add here is, the stored procedure returning the tabular data sets is locked and i don't have access to read/alter it.

i dont have access to RS DB.

use ISNULL function while doing the final substraction

@Daysleft = ISNULL(@TotalDays,0) - ISNULL(@DaysTaken,0)

If my assumption is correct, the following code should work...

SELECT t_facility.source_system as System_ID,t_facility.last_modified,t_facility_valuation.amount

INTO #TEMP

FROM t_facility_valuation

INNER JOIN t_facility ON t_facility.facility_nr=t_facility_valuation.facility_nr

SELECT C.System_ID,C.last_modified

, SUM(C.amount) CurrentAmount

, SUM(P.amount) PreviousAmount

,SUM(C.amount)-SUM(P.amount) VarianceAmount

FROM #TEMP C

INNER JOIN...