Hi all.
I am new to SQL Server and have been trying to set up a DTS package that imports data from our Oracle Server to our SQL Server. Using ActiveX transformation all works well until I intoduce a call to a SQL Server UDF I created to handle the extraction of data elements from within a specific input field. My question is "Can one call a UDF from within the VB Script in the DTS ActiveX package? I tried to do this by simply stating...
DTSDestination("Location") = UDR.dbo.getLocation(DTSSource("input_field_with_location"))
However this fails saying it cannot identify the server. (Can't recall the exact error msg, but that's the gist of it)
The UDF is part of the local SQL database (not the master). I have scoured the message boards on the NET and have yet to find an answer as to whether or not this is doable. If it is, can someone please point me in the proper direction? Of if it is not, please tell me so this way I can stop beating my head against the wall!
Thanks in advance.
Vince