Does anyone know, if possible, how to call a user-defined function from a DTS package? I have date fields in several comma delimited text files that need the same reformatting before I can use them, but I don't want to rewrite the procedure evertime. Thanks for the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Function Call from DTS
- Thread starter ras1107
- Start date
Can you be more specific as to where in the DTS package you want the function to be called? If it is in a transformation that utilizies lookups then I would say make the function call from within lookup SQL and return whatever the function returns. In general you can call a function from anyplace in a DTS package that you can build a SQL statement.
- Status
Similar threads
