Dear Eric, I need to copy tables from a Tandem box to a SQL server database. I have tandem consultants that want to use FTP in order to do this but I have no FTP experience at all. What needs to be done on the SQL side in order to make FTP work? Do I need to worry about login IDs in any way coming from Tandem. Any help would be greatly appreciated.

-- Anonymous, August 03, 2000

Answers

Nathan,

The FTP Server Service is part of the Internet Information Server (IIS).

To administer FTP, open IIS's Internet Service Manager (this server may be different than your SQL server). Under your server name, right click on 'Default FTP Site' and click properties.

Properly configured, the Tandem consultants will then be able to move a file to your FTP directory. You can then schedule a SQL Server job to process the files.

Hope this helps,

Eric

-- Anonymous, August 10, 2000