Hello -

I am new to SSIS and quite overwhelmed at the complexity of the product.

I have six text files to be imported into six Sql Server tables (in the same
database).

I need to:
1) delete all rows (leaving only the table structure) and insert the
new data in each table
2) if one of the tables screws up, I want to roll back all insertions
for all tables.
3) schedule the job to run at 5:00 AM in the morning and notify me of
failures.

Can anyone point me in the right direction of how to find out how to do this?

Any help will be appreciated!

--
Sheldon