Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now