I'm using a CData SSIS source component within my Visual Studio data flow. The connection to the data source 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?
Best answer by Lance R
View original