# SSIS- Unable to bind the parameter

**URL:** <https://community.cdata.com/t/ssis-unable-to-bind-the-parameter/507>\
**Category:** Editions\
**Tags:** article, ssis, paramaterized-queries\
**Created:** [November 3, 2023, 7:59pm UTC](https://community.cdata.com/t/ssis-unable-to-bind-the-parameter/507 "2023-11-03T19:59:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erjol\_Sulku](https://avatars.discourse-cdn.com/v4/letter/e/958977/32.png) [@Erjol\_Sulku](https://community.cdata.com/u/Erjol_Sulku)\
**Post date:** [November 3, 2023, 7:59pm UTC](https://community.cdata.com/t/ssis-unable-to-bind-the-parameter/507/1 "2023-11-03T19:59:46Z")

</div>

This error is encountered while working with SSIS (SQL Server Integration Services) and utilizing parametrized queries. There are a couple of common reasons why you might encounter this error:

1. You are using a parametrized query in this format:

Select \* from [table] where column=?;

2. You are using an SQL query similar to the one below, but the parameter name in the “Parameters” window does not match the one set in the SQL query:

Select \* from [table] where column=@value;

 ![ba8e43dc-502e-465b-86c3-bbdd9d85b569.png](https://us1.discourse-cdn.com/cdata/original/2X/4/4f1e230907be44846a14b31f44e95ad7b08bbc33.png)

Here is an example of how your SQL query syntax should look like and how the “Parameters” window needs to be configured in order to overcome the error:

SQL Query:&nbsp;&nbsp;

Select \* from [table] where column=@value;

Parameters window:

 ![19d787fe-8eb5-496f-b9f9-ec08a02db16d.png](https://us1.discourse-cdn.com/cdata/original/1X/7d2dcc3bdbc64bfd773750711f141ea75e9e0c0a.png)

Please reach out to [support@cdata.com](mailto:support@cdata.com) if this does not resolve the problem for you.