SQL 2000 error running DTS package

I have a DTS package built that copies data from one SQL server to another using the "copy sql server objects" setting.  This package executes every hour, 5 days a week.  It has been running perfectly fine for weeks, but today it stopped running.  The error I get when I try to manually execute the package is "sql-dmo the bulk copy execution failed"

HELP!  I'm not a SQL expert (but I am willing to learn).
Who is Participating?
Anthony PerkinsCommented:
Is Logging on?  Hint:  Look up Package Properties.
bella28Author Commented:
I just figured it out, someone added a field and I do not recreate the table every time the package executes.  But thanks for the help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.