Share via

Export Column Transformation in SSIS is not working.

Rainbow1517 21 Reputation points
2023-07-01T05:58:30.36+00:00

I use Export Column Transformation to read data in a data flow and insert the data into a file in SSIS (Visual Studio 2019). When I open Export Column Transformation Editor and there are no options, see below.

Does anyone know what the issue is?

User's image

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,666 Reputation points
    2023-07-03T02:00:04.62+00:00

    Hi @Rainbow1517,

    The transformation creates the files, if they do not already exist, and then the transformation writes the data to the files. The data to be written must have a DT_TEXT, DT_NTEXT, or DT_IMAGE data type. For more information, see Integration Services Data Types.

    Check: Export Column Transformation

    Please double check your source data.

    Regards，

    Zoe Hui

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

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.