Hi,

My problem is as follows:

I have a SQL Server 2000 database, for which I have done a DTS Export
to MS Access. A Visual Basic file has been generated. I have compiled
the file to an executable.

I have tried to run the executable, but I didn't manage to get all my
SQL tables being exported. I have started with 2 or 3 tables. That
worked.. Then I tried to export all tables, now the executable hangs,
it doesn't report any error (package.failonerror = true). Do I have
overseen something?

I now that using VB files generated by the DTS Import/Export wizard is
a straightforward, but limited way of accomplashing DTS tasks, but at
least it should be working!?

Thanks and best regards,

Hugo Faber