I am a network admin and new to SQL. I have a SQL project and need your
assistance and thoughts. What I am setting up is this.... Inside our
network we have SQL 2000 Server "A" that has a production databases. At
10:00 PM three complex SQL queries run on SQL Server "A" and export the data
to three ASCII files to the C:\SQLOut folder. At 10:30 PM an FTP program
kicks in on Server "A" to move the three files to a SQL 2000 Server "B" in
the DMZ. At 11:00 PM these three files are used to update three Server "B"
database files.

I have the SQL statements written but not sure if this should be a DTS
package. Also not sure how to setup the DTS package or the SQL statements to
run at 10PM on the export and 11PM on the import.

What is the best way to handle this and can you point me to some
documentation on how to set this up?

Thanks!

--
NC Beach Bum

You do not need DTS but here is how I would do this

1. Export To text File (SQL Server Agent Job)
2. FTP using ftp.exe the file(s) to the other server (Same SQL Server Agent
Job)
3. Use BULK INSERT (TSQL Statement) in a SQL Server Agent job on the other
server.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"NC Beach Bum" <NCBeachBum (AT) discussions (DOT) microsoft.com> wrote