i am using a OLE DB Source in my dataflow component and want to select rows from the source based on the Name I enter during execution time. I have created two variables,
enterName - String packageLevel (will store the name I enter)
myVar - String packageLevel. (to store the query)
I am assigning this query to the myVar variable, "Select * from db.Users where (UsrName =ÃÂ " + @[User::enterName] + " )"
Now in the OLE Db source, I have selected as Sql Command from Variable, and I am getting the variable, enterName,. I select that and when I click on OK am getting this error.ÃÂ
ÃÂ Error at Data Flow Task [OLE DB Source ]: An OLE DB error has occurred. Error code: 0x80040E0C.An OLE DB record is available.ÃÂ Source: "Microsoft SQL Native Client"ÃÂ Hresult: 0x80040E0CÃÂ Description: "Command text was not set for the command object.".
Can Someone guide me whr am going wrong?
myVar variable, i have set the ExecuteAsExpressionÃÂ Property to true too.
Please let me know where am going wrong?
Thanks in advance.
View Complete Post