May 26, 2011 at 7:47 am
HI All,
I Am getting the below error message when i clicked the "parameters mapping" tab in the OLEDB source editor. SOurce is : SQL server 2008
Error message:
Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.
Note: I cannot store and use the SQL statement in the variable since the query is too high. It contains more than 12000 characters.
Please provide a solution to this problem.
Thanks in advance.
May 27, 2011 at 12:28 am
What syntax did you use to indicate the parameters?
Another option is to use a stored procedure in the source.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 27, 2011 at 7:34 am
Parameter mapping does not work in cases with an even marginally complex query. In those cases you often have to resort to sprocs. And 12K is a fairly big script.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply