Wednesday, January 09, 2013 2:41 PM
I am loading an entity through the staging/SSIS. I have a resource entity that has a resouces name and a role.
There is a role entity with all the roles available and there respective code. I need to have the role code in the staging for it load resource entitty. If I have the actual role, I get an error.
How can I get it to load the role name and then find the code? else I have to put lookups in place and thats gonna be a ball ache.
Monday, January 14, 2013 5:23 AM
You have to design your SSIS package in such a way that, you load the Role entity first and then the Resource entity. You will also need to create a subscription view on Role entity. While loading Resource entity, lookup with the Role subscription view and enter the corresponding codes in Resource staging table.
Lookup is required here. No skip from it.
Let me know if you need more details.
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Friday, January 18, 2013 1:28 AM