Table Switch Won't!

I am trying my first sliding partition scheme with 2005, and I am getting the following error...


ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table "ScanStoreAggregateLoad' allows values that are not allowed by check constraints or partition function on target table "ScanStoreAggregateTest'.


I have gone over the functions and constraints a gazillion times. The columns are set to Not Null. The constraints are set to AND NOT NULL. The constraint values align and align with the function. But still I get the failure. Any help would be greatly appreciated. Here are the definitions:


CREATE PARTITION FUNCTION pfn_ScanStoreAggregate(int)

AS

RANGE LEFT FOR VALUES

(19224,

19225,

19226,

19227)


CREATE TABLE dbo.ScanStoreAggregateTest(

ProductID int NOT NULL,

DateKey int NOT NULL CONSTRAINT ck_ScanStoreAggregateRange CHECK ((DateKey BETWEEN 19224 AND 19227) AND (DateKey IS NOT NULL)),

Span tinyint NOT NULL,

LocationID smallint NOT NULL,

WeeksTY tinyint NOT NULL,

WeeksLY tinyint NOT NULL,

UnitsTY numeric(12, 2) NOT NULL,

UnitsLY numeric(12, 2) NOT NULL,

SalesTY money NOT NULL,

SalesLY money NOT NULL,

CostTY money NOT NULL,

CostLY money NOT NULL,

ACVTY money NOT NULL,

ACVLY money NOT NULL,

SalesPerMMACVTY money NOT NULL,

SalesPerMMACVLY money NOT NULL,

) ON ps_ScanStoreAggregate (DateKey)


CREATE TABLE dbo.ScanStoreAggregateLoad(

ProductID int NOT NULL

,DateKey int NOT NULL

,Span tinyint NOT NULL

,LocationID smallint NOT NULL

,WeeksTY tinyint NOT NULL

,WeeksLY tinyint NOT NULL

,UnitsTY numeric(12, 2) NOT NULL

,UnitsLY numeric(12, 2) NOT NULL

,SalesTY money NOT NULL

,SalesLY money NOT NULL

,CostTY money NOT NULL

,CostLY money NOT NULL

,ACVTY money NOT NULL

,ACVLY money NOT NULL

,SalesPerMMACVTY money NOT NULL

,SalesPerMMACVLY money NOT NULL

) ON DataAggregates



ALTER TABLE dbo.ScanStoreAggregateLoad

WITH CHECK

ADD CONSTRAINT ck_ScanStoreAggregate19227_DateKey

CHECK ((DateKey = 19227)

AND (DateKey IS NOT NULL))