Thank you, but where do I check or uncheck the option for SQL to append in DTS - I did this and saved the job in DTS, but never saw...

I am fairly new to SQL and have a great automatic way to do this:

I have 2 Servers, Windows 2003 Standard, both with SQL Server 2000 and sp3a.

I have a...

I am fairly new to SQL and have a great automatic way to do this:

I have 2 Servers, Windows 2003 Standard, both with SQL Server 2000 and sp3a.

I have a...