How to insert into Anchor tables using SSIS

nsandhia

Hi,

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.

Thanks!

Thanks,

Sandy