I need to call a function to calculate a value. This function accepts a varchar parameter and returns a boolean value.ÃÂ I need to call this function for each row in the dataflow task. I thought I would use an oledb command transformation and for some reason if I say..
'select functioname(?)' as the sqlcommand, it gives me an error message at the design time. In the input/output properties, I have mapped Param_0(external column) to an input column.
I get this erro.."syntax error,ÃÂ ermissionÃÂ violation or other non specific error". Can somebiody please suggest meÃÂ what's wrong with this andÃÂ how should I deal this.
Thanks a lot!!ÃÂ
View Complete Post