Share via

SSIS Data Conversion editor, what is maximum numbers of columns ?

GRIFFITH, MICHAEL 1 Reputation point
2022-12-07T18:57:27.193+00:00

have a query returning 501 columns wide. appears data conversion editor only showing 498 columns. any suggestions on how to resolve?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-12-08T03:04:00.513+00:00

    Hi @GRIFFITH, MICHAEL ,

    There is no official documentation mentioned about the maximum numbers of columns in SSIS data conversion editor.

    I think it depends on the limitation of the SQL server table which is 1024.

    I created a table with 500 columns and in the data conversion it also shows the 500th column.

    268407-image.png

    Please double check your source and try to re-add the source component and the data conversion component.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.