Writing Exception Messages to File Log from Transform Data Task ActiveX

• Bryan T. Ogden

  Grasshopper

  Points: 11

  More actions

  November 19, 2005 at 11:55 pm

  #69907

  I am a newbie to DTS and have been using the package designer to create an ETL process.  In the Transform Data Task I have usually needed an ActiveX script for each mapped source to destination transform.  In these ActiveX scripts I am validating source data before passing it through to the destination.  However, I have not been able to find any way to log my own exception messages about the invalid data I find.  I have tried using the DTSPackageLog.WriteStringToLog method but it errors with something like "Object required: DTSPackageLog".  So where to I get a reference to a PackageLog and what log file does WriteStringToLog write to?  Is there another way to log messages from within a Transform Data Task ActiveX script?

  I know that you can "flip" over to complete program control of packages, steps and tasks and probably log exception messages but these seems like overkill to get message into a file.  I seem to be 95% there using the package designer but can't seem to complete with the exception logging I need.

  Any suggestions?

  Thanks, Bryan.

   

• Saravanan V

  SSC Enthusiast

  Points: 186

  More actions

  November 20, 2005 at 10:13 pm

  #604857

  Hi,

  Try to use file system object in your script and write your own exception file and send it to respective user.

  Regards,

  Saravanan.

  ---

  Kindest Regards,

  Saravanan V
  geocities.com