SAP Knowledge Base Article - Preview

2579736 - Create Table failed because table exceeds the max column limit - Data Services

Symptom

  • Reading a CSV file with thousands of columns into a Microsoft SQL Server template table will fail.
    Error "<[Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE failed because column 'F1025' in table exceeds the maximum of 1024 columns.>


Read more...

Environment

SAP Data Services 4.x

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2

Keywords

KBA , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.