Post reply

How to use table valued function with parameter in ole db source

  • March 24, 2010 at 5:04 pm

    #386577

    Hi Everyone,

    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.

  • March 24, 2010 at 10:15 pm

    #1139388

    Hi Everyone,

    did anyone experienced this type of problem.

    Thanks in advance...

  • March 25, 2010 at 9:11 am

    #1139717

    SQL command from Variable should work..What is the Error that you are getting ? Are the SSIS variable data types same as your Function variables ??

  • March 25, 2010 at 10:38 am

    #1139798

    I just thought of something.

    You need to have the command in the variable at design time so just put one in so the designer has something to work with.

    CEWII

  • March 26, 2010 at 8:06 am

    #1140362

    Hi Elliot and Divyanth,

    Thanks for your replies. I will try with your solutions and I'll let you know whether I am able to execute the table valued function or not.

    Thanks once again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply