I need to bulk copy several access tables into SQL 7, completing the tasks in the following order :
Drop SQL Table
Re-create SQL Table
Set some Permissions
Move the data from Access into SQL table
BUT, if any task fails I need the table to still exist in the state it was before starting the tasks. I've got a DTS package that looks like it should work, but if a task fails it refuses to call my SQL command, rollback. HELP!
In Advance - Thanks.