Ho to use User Defined Function in SSIS?

Question

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

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

Phil Parkin SSC Guru Points: 246988 More actions · Answer 1

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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

raghavender.2369 SSC Eights! Points: 833 More actions · Answer 2

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