Output to flat file

Christopher Jack 1,606 Reputation points
2021-09-02T14:55:00.63+00:00

Hi,

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

128717-image.png

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
    2021-09-03T02:27:49.983+00:00

    Hi @Christopher Jack ,

    Thanks for your reply, please refer below test.

    Update:

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

    129074-screenshot-2021-09-03-171718.jpg

    It should work in this way like shown.

    129009-screenshot-2021-09-03-171829.jpg

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

    Regards´╝î

    Zoe


    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