How can I insert records into the Anchor tables using SSIS?
AC_Account is the Anchor I created. Manually inserting into the [dbo].[lAC_Account] View works as shown in one of the tutorials.
However when I try to insert into this view using SSIS package it throws an error - View or function 'dbo.lAC_Account' is not updatable because the modification affects multiple base tables.
I am not an expert in SSIS as I am still learning. I am not sure what task should I use in the data flow to insert record into Anchor table.
Please note that I have unchecked the Use Metadata option as I did not need it. I am not sure if this makes a difference.