I have a package where in I have to use a table valued function which accepts parameter from a package variable in OLE DB SOURCE.
NOTE: SQL COMMAND FROM VARIABLE (DATA ACCESS MODE).
I also tried it generating a sql statement including parameter in script task and I tried using it in OLE DB SOURCE but it is giving following error.
ERROR: COMMAND TEXT NOT SET FOR A COMMAND OBJECT.
Please let me know if any one has any solution for this problem.
Thanks in advance.