SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error:

The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store. The operations(s) will not be generatred. Recreate the operations(s) with less number of columns in the configuration.

The database table has 188 columns (I did not design this legacy system. I am shocked myself how big that is).

Is there a way I can get BCS to connect to it? I am connecting via SPD would using VS make any difference?

If not I will need to look at creating my own data layer and access the content in a custom web part.

share|improve this question
I am wondering if you ever solved this? can you please share our solution and update this post? Thank you. – lucas May 8 '15 at 5:32
up vote 0 down vote accepted

Do you really need all 188 columns?

I would create a SQL View or Stored Procedure that interacts only with the data you need.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.