Post reply

Call function from DTS....

  • November 27, 2007 at 12:42 pm

    #180855

    Hi Experts

    I want to execute function which is going to use as table

    like

    ( In Transform Data task properties - SQl Query as)

    select * from testven(?,?)

    It shows error message as

    Error Source: Microsoft OLE DB Provider for SQL Server

    Error Description: Syntax error or access violation

    Thanks in advance

    S.V

  • November 27, 2007 at 3:51 pm

    #754761

    It doesn't work with functions.

    Just encapsulate the function in a stored proc and it will work fine.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

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