Great point. We are a small operation so far so it would be me solving the problem at 2AM. As this is my first use of SSIS, I was just experimenting so I could rerun all over and over to debug but, when I got it working I truncated all the tables and then did a final run. Next step is to set up the keys so duplicates won't be imported and define relationships between some of the tables to group tasks in a package or run solo if not related. I'll be doing transformations, ftping the files, etc. as I develop this to be a fully automated system.

Because the IT team had been doing almost everything by hand using Excel and Access (no VBA or macros even) I thought I would get this going to show them how to take the manual drudgery out of their job. They'd never heard of SSIS so I have some time to learn as I go to make a data warehouse with nightly automatic report data refresh.

Thanks again.