Can't create a flat file source

Tarik Fathi 1 Reputation point
2022-10-11T17:39:01.99+00:00

Hi,
I'm getting an error when trying to create an connection manager for a flat file. All other types of data managers work fine (like Exel, OLE DB...) exept for "Flat File Connection".

I also noticed that all the flat file connection in my older packages are showing an error now. Is it a bug in Visual Studio ?

249462-capture.png

Thank you in advance.

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points
    2022-10-12T05:41:48.377+00:00

    Hi @Tarik Fathi ,

    What's your version of the VS and integration service project?

    If you create a simple package and add the flat file source, will it fail?

    If the error still occurs, please try to repair the VS.

    249592-image.png

    Regards,

    Zoe Hui


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

    0 comments No comments