Hi

I execute a dts package from an Access database to import SQL Server tables
into the Access database.

It works and fails randomly! As a last resort, I executed the package in a
loop so it tries 10 times before telling the user it has failed. This has
worked around the problem as it generally succeeds before the 10th try but I
would love to know if there is a reasonable explanation for why sometimes it
works and others not.

Thanks in advance

Are you logging the package execution?
If not then do so. Hopefully you will see messages in the logs that give
you an idea why it fails.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"GH" <grada (AT) nda (DOT) com.au> wrote