SQL Command text with parameter OLEDB Source
oledb, prepared-statement, sql, ssis
Solution
You are doing the right thing, but it is the "Preview" that is not working for parameterized source tasks. Try executing the package and you should be ok.
Problem
I am working with SQL Server Integration Services 2008. In my Data Flow task I got a OLEDB source. I choose SQL command as the Data Access mode and following is my sql text ``` Select * from table1 where ID=? ``` And from parameters tab my Parameter Name is zero "0" and value is coming from a package level variable. I tried to replace the parameter name with "Parameter0" but I always get the same error that ``` Error: "No Value given for one or more required parameters" ``` But there is a value for my variable