Hi All, I have a table with the following fields. SERVICEID,DATEOPENED(DATETIME),DATEOPENED_ID(INT). And i have a time DIM with the following fields: ID,PK_Date,Date_Name,Year,Year_Name... In BIDS i opened a PACKAGE and i wanted to populate the field DATEOPENED_ID, with the following query using the EXECUTE SQL TASK Transformation: update dbo.TABLENAME set DATEOPENED_ID = ID from [dbo].DIM_TIME where DATEOPENED = PK_Date GO update dbo.TABLENAME set DATEOPENED_ID= -1 where DATEOPENED_ID is null GO And when i execute the TASK all i see is '-1' in the DATEOPENED_ID field in the NULL instead of ID values from the TIME DIMENSION. Can anyone please tell me where i'm going wrong? Thanks

Very simply I guess the DATEOPENED = PK_Date condition does not materialize, thus you only get all updated to -1 and there is no your fault or SSIS's. Arthur My Blog

Thanks Arthur but when i run the following query to check the dates between the two tables i'm getting data. select t1.*,t2.* from dbo.tablename t1,dbo.DIM_TIME t2 where LTrim(RTrim(t1.dateopened))=LTrim(RTrim(t2.pk_date))

the TRIMs are important, your query in SSIS must be EXACTLY the same to workArthur My Blog

Thanks i tried and am getting far fewer rows, but will post the results when i execute the task again.