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.
9,884 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 22,216 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
  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
  3. ZoeHui-MSFT 22,216 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.