Hi,
I am trying to set the OLE DB Source Editor. I am using the following option for Data Access mode
SQL Command from a variable and uses my sqlQuery variable.
sqlQuery variable contains a sql statement but I am getting the following error
ox80040E0C, Command text was not set for command object,
Additional information HRESULT 0xC0202009
Does it mean I have to give the variable name containing the stored procedure
Please Guide
OLE DB Source & SQL Command
JGMiller
Ignore this, When I pass the name of stored proc it works fine
Thanks for you help
Sami Zeitoun
Do you get the error at design-time or runtime
What value is in @[User::sqlQuery]
-Jamie