Hi, I am working in Microsoft SQL server 2000. I am currently working in DTS. I need to email an user if the source data is not valid.
Is this possible using ActiveX script in Transformation under Transform Data Task Properties ?
If this is not possible, is there a way that I can write the error info to a file and later have a ActiveX task to email the file. Any help will be greatly appreciated.