# The configuration window for SSIS source component closes when I hit the parameter button

**URL:** <https://community.cdata.com/t/the-configuration-window-for-ssis-source-component-closes-when-i-hit-the-parameter-button/157>\
**Category:** CData Drivers\
**Tags:** sql, question, ssis, visual-studio\
**Created:** [April 21, 2023, 8:50pm UTC](https://community.cdata.com/t/the-configuration-window-for-ssis-source-component-closes-when-i-hit-the-parameter-button/157 "2023-04-21T20:50:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lance\_R](https://avatars.discourse-cdn.com/v4/letter/l/e95f7d/32.png) [@Lance\_R](https://community.cdata.com/u/Lance_R)\
**Post date:** [April 21, 2023, 8:50pm UTC](https://community.cdata.com/t/the-configuration-window-for-ssis-source-component-closes-when-i-hit-the-parameter-button/157/1 "2023-04-21T20:50:45Z")

</div>

I’m using a CData SSIS source component within my Visual Studio data flow. The connection to the data source&nbsp;is working fine -- the problem is I can’t define parameters for my SQL expression. I open the configuration editor for the source component and enter a SQL expression that contains a parameter (e.g., “Select \* from Customer where Name = @param”). Then, when I hit the “Parameters” button, the configuration window suddenly closes.

How do I get past this so I can define the parameter?

---

<div class="post-metadata">

**Author:** ![Lance\_R](https://avatars.discourse-cdn.com/v4/letter/l/e95f7d/32.png) [@Lance\_R](https://community.cdata.com/u/Lance_R)\
**Post date:** [April 21, 2023, 8:54pm UTC](https://community.cdata.com/t/the-configuration-window-for-ssis-source-component-closes-when-i-hit-the-parameter-button/157/2 "2023-04-21T20:54:34Z")

</div>

This closing behavior after hitting the parameters button is an issue with using CData SSIS source components within Visual Studio 2019 and Visual Studio 2022. You’ll need to modify a Visual Studio configuration file to fix this problem.

First, close Visual Studio if it is open.

For Visual Studio 2019:

Navigate to your Visual Studio 2019&nbsp;installation directory and locate the file:&nbsp;  
_“Microsoft Visual Studio\2019\Community\Common7\IDE\devenv.exe.config”_

Make a backup of the&nbsp;_“devenv.exe.config”_&nbsp;file just in case a typo is introduced during the edit.

Open the file in a text editor and scroll until you find the last “\<dependentAssembly\>” XML block. Add the following XML block to the file:

```auto
<dependentAssembly> <assemblyIdentity name="Microsoft.DataWarehouse.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/> <bindingRedirect oldVersion="10.0.0.0-16.2.0.0" newVersion="15.0.0.0"/></dependentAssembly>

```

Save and close the file. The parameter button should work as expected when you open Visual Studio 2019&nbsp;back up.

For Visual Studio 2022:

Navigate to your Visual Studio 2022 installation directory and locate the file:&nbsp;  
_“Microsoft Visual Studio\2022\Community\Common7\IDE\devenv.exe.config”_

Make a backup of the&nbsp;_“devenv.exe.config”_&nbsp;file just in case a typo is introduced during the edit.

Open the file in a text editor and scroll until you find the last “\<dependentAssembly\>” XML block. Add the following XML block to the file:

```auto
<dependentAssembly>    <assemblyIdentity name="Microsoft.DataWarehouse.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/>       <bindingRedirect oldVersion="11.0.0.0-17.3.0.0" newVersion="17.3.0.0"/> </dependentAssembly>   

```

Save and close the file. The parameter button should work as expected when you open Visual Studio 2022 back up.