The following link will allow you to download the integration kit for MSSQL Server:
Once downloaded, you can simply unzip the folder and modify the following two files:
The run.cmd file only needs to be updated with the following parameters:
db_server is the name of your database server -- this could be the DNS name or the IP address
db_user is the MSSQL user you want to use to connect to the database server
dp_password is the database user password
db_name is the name of the SQL Server database
ftp_user and ftp_password will be supplied to you from Angela's team for the FTP account to be used for the file transfers
Finally, the scripts contained will automatically archive the files sent up to the number set in days_to_keep_sent_files
If an error occurs when processing the files and does not transfer to our FTP site correctly, it will simply remain queued to be sent on the next attempt.
The query.sql file is what contains the SQL statement that the scripts will convert to a tab delimited text file. This can also contain a call to a stored procedure which is how I'd recommend setting it up.
To run it, you simply double-click the run.cmd file -- which can then be scheduled into the Windows scheduler to be run each night.