How to change flat file connection settings or delete already created connection?

techresearch7777777 1,796 Reputation points
2022-09-29T23:06:57.29+00:00

Hello, I have VS 2019 Community Free edition along with "SQL Server Integration Services Projects" and started created an Integration Services Project.

I created a New Connection type Flat File.

If I want to change its connection settings or delete this connection how do I do that?

I looked in Connection Managers within Solution properties window and nothing shows and tried checking everywhere within Visual Studio and couldn't locate mechanism to do.

Thanks in advance.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2022-09-30T05:48:40.103+00:00

    Hi @techresearch7777777 ，

    You may change or edit the connection via connection manager as shown below.

    Right click on the connection. If I misunderstand your issue, please incorrect me.

    246299-untitled.png

    Regards，

    Zoe Hui

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

    0 comments
  2. techresearch7777777 1,796 Reputation points
    2022-09-30T06:05:53.713+00:00

    Thanks Zoe Hui for your reply.

    I do have an already established connection but nothing looks like is listed within "Connection Managers" in following screenshot:

    246288-image.png