Hi there

I have a DTS package
which deletes records from some tables (there are around half a million records totally). And fetches records from different SQL Server using "Insert into" statements. The problem is the transaction log is getting filled at the first part, deleting records itself. I have listed the restrictions at the server.

Restrictions
------------
Cant go for BCP as there is no file write permission.
There is no permission for truncate command.
Cant make transaction log autogrow.
The max size is set to 40 MB.

I think that batch execution is a way out. But i have not used it and not sure.

I would be very grateful for any help on this.

Thanks
Vinod