Hi NG
I read a lot of articles about "DTS and functions/SPs" but i guess i didn't
get it at all.
So, here's my code with which i tried to integrate a function call inside a
data transformation. And it doesn't work.

'************************************************* *********************
' Visual Basic Transformation Script
' Copy each source column to the
' destination column
'************************************************* ***********************

Function Main()
DTSDestination("Artikelnummer") = DTSSource("Artikelnummer")
DTSDestination("Suchbegriff") = DTSSource("Suchbegriff")

--that's the function call that doesn't work!!
DTSDestination("Datumletztenderung") =
dbo.udfDTFromDecimal2(CONVERT(numeric(6,0),DTSSour ce("Datumletztenderung")))

DTSDestination("LetzterEkPreis") = DTSSource("LetzterEkPreis")
Main = DTSTransformStat_OK
End Function

Thanks,
Steffen

Inside the script which is where you are now you do not have access to
objects outside in this way.

Either

Use the TSQL function in the SourceSQLStatement of your datapump

OR

Create a VBScript version inside the Active script transform and use that.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Steffen Klipfel" <steffen.klipfel (AT) no (DOT) spam> wrote