I'll state it another way. I will be inserting a record into a table and that table will create a new row guid. how do I access the new row...

How would I access the new foriegn key from the first load? Sorry if this is a newby question kinda new to SSIS.

I tried but I'm getting the following error:

[Derived Column [394]] Error: An error occurred while attempting to perform a type cast.

I added a conditional split with the following in...