Im writing a DTS package which goes through multiple steps of importing data. Im looking to write to a single log file for the process. Using the wizard tools I can write to the file however the previous data written is overwritten with the new data instead of the process appending the new data. I have come across FileSystemObject references on the web but due to my inexperience with ActiveX VB I am unable to properly write a function. Im looking for a function I can use instead of using the Text File (Destination) connection in my package so that I can append the data to the file.
Start Free Trial