none
Table-valued user-defined functions RRS feed

  • Question

  • Is there a way to execute a table-valued user-defined function within SSIS - one that no only returns a "table" of values but also passes in variables to the udf?  Example of it in query form:

    DECLARE @Var1 INT

    SET @Var1=ID FROM dbo.dbtable WHERE Status = 1

    SELECT * FROM udf_Foo(@Var1)

     

    Thanks.

    Friday, January 13, 2006 6:00 PM