I'm a newbie with DTS. So here goes...
I have about 10 transformations that I have in my DTS package. Right now I have an ActiveX script for each source-to-destination column mapping.
A problem has arisen that could be alleviated by being able to have a central function that does the following: have a value passed in, perform certain checks on that value, if the value doesn't pass these checks, then return null to the calling function.
For example, have each ActiveX script in my source-to-destination column mappings call this centralized function and pass in my source column value and get back a value that is put in the destination column.
I could do this the "brute force" way and just write the same function into each ActiveX script, but I would like to avoid that if at all possible.
It certainly would make maintenance easier if I could somehow have this function in a central locatioin and just have all the source-to-destination column mappings call it each time.
Is this possible in DTS or will I have to scrap DTS and do everything from VB.
I have about 10 transformations that I have in my DTS package. Right now I have an ActiveX script for each source-to-destination column mapping.
A problem has arisen that could be alleviated by being able to have a central function that does the following: have a value passed in, perform certain checks on that value, if the value doesn't pass these checks, then return null to the calling function.
For example, have each ActiveX script in my source-to-destination column mappings call this centralized function and pass in my source column value and get back a value that is put in the destination column.
I could do this the "brute force" way and just write the same function into each ActiveX script, but I would like to avoid that if at all possible.
It certainly would make maintenance easier if I could somehow have this function in a central locatioin and just have all the source-to-destination column mappings call it each time.
Is this possible in DTS or will I have to scrap DTS and do everything from VB.