Hi There,
i have created one view on an exsisting table, but when i am inserting value in it, it is giving the following error msg:
Derived table 'View Name' is not updatable because a column of the derived table is derived or constant.
Thanx
Is this related to SSIS? Well the error is coming straight from SQL Server itself, and is fairly clear to me.
You cannot update a column that is not really a column. So what columns are being updated and can you honestly say they are unadulterated columns, and have not been derived or manipulated in any way before being returned from the view.?
If you want a specific answer then post the UPDATE statement and a the DDL (CREATE VIEW...) for the view.
No comments:
Post a Comment