I agree with the previous post -- within the ActiveX Script, use FSO to loop through and get all of the filenames within a directory.  Then you can use ADO...

I recommend that you go with pacarter's suggestion of using a solution from http://www.sqldts.com

If you don't want to use the DTSBackup2000 tool, you can transfer them manually using DTS...

I recommend that you go with pacarter's suggestion of using a solution from http://www.sqldts.com

If you don't want to use the DTSBackup2000 tool, you can transfer them manually using DTS...

http://www.sqlservercentral.com/testcenter/qod.asp

Scroll to the right and click "Answer" -- the questions that you have already answered shows if you got it right/wrong

From BOL...

Note  If you experience a problem using the FTP task, use http://ftp.exe in a command prompt to help identify the problem, as both the FTP task and

Please excuse my ignorance concerning telnet and rsh.

Question on both of the suggestions:  How do you specify the password to log into the remote server?  When you open a telnet...

You could also use ADO to get at this information...

Set rsobject = connectionobject.OpenSchema (QueryType, Criteria, SchemaID)

The OpenSchema method returns a read-only RecordSet object that contains...

Just out of curiosity, how much time did it take for the queries to execute?

Do not close your connection after creating each recordset -- use the same connection, so you get something like...

myRS.Open mySQL1, myConn

myRS.MoveFirst

DTSGlobalVariables("minPeriod_rdataload").Value = myRS(0)

DTSGlobalVariables("maxPeriod_rdataload").Value = myRS(1)

'myConn.Close

myRS.Open mySQL2, myConn

myRS.MoveFirst

DTSGlobalVariables("maxPeriod_rdataloadall").Value = myRS(0)

'myConn.Close

myRS.Open mySQL3,...

myConn.ConnectionTimeout = 0

sets the timeout value to "unlimited"

What problems are you referring to?

You can accomplish this task in an ActiveX Script using ADO...

 Set myConn = CreateObject("ADODB.Connection")

 Set myRS = CreateObject("ADODB.Recordset")

 myConn.ConnectionString = "Provider=SQLOLEDB;Data Source=yourServerName;

                                             Initial Catalog=yourDatabase;Trusted_Connection=Yes"

 myConn.ConnectionTimeout = 0

 myConn.Open

 mySQL = "SELECT DISTINCT yourField FROM yourTable...

Schedule the DTS as a Job and then it will run on the server under the SQL Agent accounts credentials.

If need be, you can start the JOB remotely.

The way that I accomplish this task is to create a DTS, add an "Execute Process Task" and call a batch file that calls the FTP script.  So the Win32...

Keep in mind that when you run this interactively, it uses your credentials to execute, but when you schedule the task as a job, the SQL Agent's credentials are used. ...