Advertisement

05.17.2007 at 11:52AM PDT, ID: 22578963
[x]
Attachment Details

FileSystemObject in VBA

Asked by pjmcgovern in MS SQL DTS

I’m writing a DTS package which goes through multiple steps of importing data.  I’m 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.  I’m 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
[+][-]05.17.2007 at 12:23PM PDT, ID: 19110856

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL DTS
Sign Up Now!
Solution Provided By: dready
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32