Help converting csv in SSIS

Koudagani, Naresh 20 Reputation points
2023-05-10T02:06:56.4066667+00:00

HI Experts - I have an existing SSIS package that stopped working , and now after a while we wanted to re activate it, so we asked our vendor to send files and they sent us in a CSV file when i choose to get data from text csv and choose file, it opened like below

User's image

but the SSIS falt file connection manager is like below: and i wanted to have like below.
User's image

can some please help on how to get to the format i wanted please?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,107 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,491 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2023-05-10T03:17:26.4833333+00:00

    Hi @Koudagani, Naresh,

    When you configure the Flat file manager, use the header row to skip.

    User's image

    Regards,

    Zoe Hui


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

    0 comments No comments

  2. Koudagani, Naresh 20 Reputation points
    2023-05-10T04:26:23.95+00:00

    Hi Zoe- Thanks for looking but that didn't help , pasted the below output after header rows skip=2
    User's image

    0 comments No comments

  3. ZoeHui-MSFT 34,581 Reputation points
    2023-05-10T05:38:15.3033333+00:00

    Hi @Koudagani, Naresh,

    Do you mean that you only want to keep the header and remove the columns after the header?

    If yes, you may use preview and then skip the rows.

    User's image

    Regards,

    Zoe Hui


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