Is it basically possible to do transactions with ssis and ms access 97! I have tried setting up a complicated package which doesn't work and then tried some transactions with a simple package which worked no problem with sql server to check I understood the principles. Now the question is does ms access support or does ssis support transactions with access 97...
Anyone have a definite answer?
Any links or tips much appreciated!
Thanks in advance...