So what if I wanted to export to pipe delimited file instead. How would this code be changed? I am struggling with exporting SP result to text file...

This is great information. However, do you have any information that would be VBScript / JavaScript specific that could implemented within a DTS package? I don't believe JAVA...

Would you be able to share that information.? The less research required the better.

Thanks,

Scott

I don't believe it is that simple. Have you tried that? Once the text file is in place I don't think that it would recognize this method

Well it is an active X script (VBScript) written within the transformations tab of the transform between the source and destination connections. Does that answer your questions?

Thanks for the input. I will take a look at that suggestion. The current method that I have working is to use the FileSystemObject command. By doing...

I guess I am not understanding the object model or vbscript enough to perform this. How would I located the destination object name to change?