SSIS Inserting null values only

I have created an SSIS package which has a Data Flow section

1/ Staging table source (has the correct data in it)
2/ Lookup with a Production table source matching all columns between the two tables with redirect row on error
3/ On error (ie does not match row) loaded into production

The package runs without error but when I look in the production table the correct number of rows has been created but all values are null
LVL 23
Michael FowlerSolutions ConsultantAsked:
Who is Participating?
Michael FowlerSolutions ConsultantAuthor Commented:
OK, I have solved the issue myself and as is always the way I found the solution just after porting the question.

In the Lookup I removed all operations and just mapped the columns and it started working. I am not sure what happened but I have the result I want and it is working perfectly
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.