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.

  • I am wondering if you ever solved this? can you please share our solution and update this post? Thank you.
    – lucas
    May 8, 2015 at 5:32

1 Answer 1


Do you really need all 188 columns?

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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