DTS errors - output them

[Katy44]

I have a DTS package with a data driven query task. It is inserting into a table or updating existing records.
When I try to run it it fails and says there was an error: "Cannot insert the value NULL into column 'ID', table '_____.dbo.NewTable'; column does not allow nulls. INSERT fails."

ID is a primary key in both the source and destination. I have also ran a query on the source, and as you would expect, it's never null.
The exception file is no help, as it just gives me the error - it doesn't give me any more of the record details.

How can I find out where this error is being thrown?

 

[dyarwood]

If you run a test on the transformation (third tab in the properties of the transform) then it will produce a text file. When the transform falls over before closing this test look into the text file and this will give you an idea of where to look into the error of the source.

 

[Katy44]

I have figured out why it was throwing the error on this ocassion, but thanks for the tip, as I'm sure that will come in useful in the future. I'll give it a go now.