Hi Michael,

I just closed it and ran it as an administrator.  I still get the same error message at the same step.

I created a copy of the target table without the constraint, replaced my target table in my SSIS data flow with this new table and everything loaded in successfully with...

Actually, I just recounted and the 16th column is School_Year_Key and the 16th value is 10

You are correct. That is weird. It's as if the records that are falling out are using the school_key as the school_year_key like the columns shifted or something....

Here is the constraint on my table:

ALTER TABLE [dbo].[APSB_FACT_SYK10] WITH NOCHECK ADD CONSTRAINT [CK_SCHOOL_YEAR_KEY_10] CHECK (([SCHOOL_YEAR_KEY]=(10)))

GO

ALTER TABLE [dbo].[APSB_FACT_SYK10] CHECK CONSTRAINT [CK_SCHOOL_YEAR_KEY_10]

GO

student_assessment_idassessment_idversion_idstudent_iddate_takenperformance_band_idpointspoints_possibleansweredpercent_correctnumber_of_questionsstudent_id_numSTUDENT_KEYSTUDENT_CURR_SCHOOL_IDSCHOOL_KEYSCHOOL_YEAR_KEYILL_ASSESSMENTS_KEYuser_idlocal_user_idlocal_user_id_charTEACHER_KEYILL_PERFORMANCE_BANDS_KEYILL_VERSIONS_KEYATT_CODE_KEYTERM_KEYTIME_KEYDISCIPLINE_KEYSTATE_TEST_KEYSTUDENT_ACTIVITY_KEYDIBELS_TEST_KEYDIBELS_CLASS_KEYHZ_EK_KEYHZ_STANDARD_KEYHZ_SUBJECT_COURSE_KEYHZ_TEST_KEYILL_REPORTING_GROUPS_KEYPERF_BAND_KEYPERIOD_KEYSECTION_COURSE_KEYErrorCodeErrorColumn

361040594058267162014-08-20 00:00:00.000450621.00000032.0000003265.6300003226716372733005271036864921782717827342880236974-9-9-9-9-9-9-9-9-9-9-9-9-9-9-9-9-10716076850

I already have several data flows...

I checked all of the look-ups and what I am doing is redirecting records where there is no match to a derived column, giving it a value -9 and then...

Ugh, that wasn't too bad 😀 Thank you for your help.

Just some food for thought, but I recently was working on updating my ETL process for building my fact table. We run a process every night. Incremental loading...

So I don't really know what is actually being fixed, but by rebooting the server, the ETL process now runs successfully when I run it manually and when run as...

I have 16 GB of RAM installed on this server with 4GB available. Also, there are no other users on this server. I run only SQL Server and...

I have 65 GB of free space. This data flow that is failing is very small in cache size and used to complete in roughly 30 secs.

I am using SSIS and I literally just saw that...

I tried using "AAAAA" and I got an error message, so I guess that means the length of the field is too long. I was just curious if there...