I do the same thing in datawarehouse evironment, but with a few tweeks.

I load my data files into a "working table" that has the same fields as the data file....

Andy,

Thanks for responding. The agent runs under a domain account with Administrator rights on the server. I can send mail through lotus notes when logged on to the...

Just another note about DTS packages. When you move a package (call it A) from one server to another and A executes another package (call it B), the newly...