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).