Hi there.

I have a problem with a task in my SQL Server 2000 DTS Package.
The problematic task is a data-driven query that performs an update of
a set of records in my "Risk" database. The task appears to run
successfully but no update takes place. In addition the exception log
for the task returns the error message

The log file for database 'Risk' is full. Back up the transaction log
for the database to free up some log space.

I have shrunk and backup/truncated the Risk log file which now stands
at 11MB and it is set to grow at 10% to an unlimited size. I then
backed up the database but this made no difference either. I tried
changing the grow size to 50% but it also made no difference.
There is 4.5GB free on the drive where the log file resides. Also the
recovery mode for the database is set to Full Recovery.

Any suggestions would be great.

Dáire