I got rid of the apostrophes, but I'm a little confused at the connection name,  Where do I find the connection name?  I have a "Microsoft OLE DB Provider for...

It does the export of the data but doesn't seem to put the time stamp on. I'm all confused

Function Main()

 Dim dt, dtstr

 dt =...

I don't want to sound like a twit, but I've never dealt with ActiveX in my life.

I've changed the "MyFile" to the actual directory it's going to  but it's still failing. ...

Sorry, here is more info. Here is the script.  The DTS package is SQL server as the source and notepad as the destination.  It goes onto another server as a...

T-SQL

I created a new job under SQL agent and wrote the script in the steps section and then created a schedule for it to run.