sql server dts: Hi,
I am running a dts package. Where can I find the log of the dts package just
run. I am curious to see the log of the dts package especially if there are
errors that will prevent all data to be imported. In that case I will be able
to analyze the errors for the data that does not get imported through dts.

Have a look at the package properties, logging tab, Error File location.
Also there is the Transform Data Task, properties, options tab which has the
Name of an Exception file....
HTH,
Paul Ibison