I've got a DTS package that is moving data from one db to another on the same
server. When the steps within the package are manually executed, all steps
succeed. However, when the package is executed, one step continually fails,
stating the number of errors exceeds the number allowed.

I've done some searching and have turned on the option to write out
exceptions on both the source and destination. When I look at the file
output compared to the table definition, etc., everything looks fine.

Has anybody come across this before and how can I get around it?

Joan

Hello jmeyers,

Are you saying that when you execute each task individually it works but
execute the package as a whole and it fails?

Why are you singling out the Datapump?

Can you enable logging at the package level and tell us what the errors say.

Maybe things are being executed out of order when the package is run in total.

Maybe you need to set things to run on the main package thread.

What is in the package?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com