go to the source tab
if you have table or view then swith to sql query write out your fields and put dbo.fn_leos_ISBNconv(FieldNameHere) around your field
I am going from a text file t a table but I an to run the function on one of the columns. I am in the Active X Script Transformation window... I don't see a source tab.
Are you importing with a Transform Data Task?
Double-click on the black line and it will pop up
It doesn't matter really since you can't do it like this if you import from a text file
import into a staging table then apply your function when you insert into the 'real' table
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.