Thanks to all who contributed.

I've got it running now by executing a job via stored procedure rather than using DTS package!

Thanks for the reply, but can't use a dos bat file due to the security set-up - I think this maybe why xp_cmdshell may not be working correctly. The package...

Hi

Your problem is quite common. I've found using DTS you can do most things you'll want to. These include validating the data, clearing down tables,appending data or updating existing records....

I assume this is SQL Server 2000. One way is to set up global variables one for success and one for failed rows to count the rows. For each row...

As regards using VB or Access as front end, having used both, both have advantages and disadvatages. If your application is an 'internal' one then it's possible you could stick...

Hi Taffy - common problem this. Firstly the transorm pump can only take one destination in the actual destination tab. However there ways of sending the data to other destinations....