Post reply

Ho to use User Defined Function in SSIS?

  • November 17, 2012 at 12:00 pm

    #393627

    Please give me one example with steps, how to use userdefined function in ssis?

  • November 17, 2012 at 12:09 pm

    #1560034

    1) Create UDF in T-SQL as usual.

    2) Add an ExecuteSQL task which calls the function, eg

    select dbo.UDF(col1)

    from tab1

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 17, 2012 at 12:13 pm

    #1560036

    Thanq so much for quick reply, but dont know how to write T-SQL function, could you plz write function for CONVERT(Monthnumber)=Monthname

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

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