Output to flat file

Christopher Jack 1,606 Reputation points


I have a ssis package outputting to a flat file, but I cannot see where to edit the destination columns.

The file connection is through a variable with the filename


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,071 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 21,986 Reputation points

    Hi @Christopher Jack ,

    Thanks for your reply, please refer below test.


    To edit the column name or add a new column, you may edit the connection manager for flat file in advance.


    It should work in this way like shown.


    About Flat File Destination, refer this official documentation: flat-file-destination



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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    4: https://learn.microsoft.com/en-us/answers/questions/142427/users-always-get-connection-timeout-problem-when-u.html 2: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/flat-file-destination?view=sql-server-ver15

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful