Skip to main content

Error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information

Error when trying to upload data into SelectHR: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand

H
Written by Harry Ledger
Updated over 3 months ago

This error message will appear if you attempt to import data into a view.
​
To resolve this, you should import data into a table rather than a view. Views often lack a primary key or unique constraint information, which is essential to carry out a successful import.

Did this answer your question?