DTS Package Hangin

  • I am loading sql 2000 on my new computer. I have plenty of DTS package developed on my old computer that run fine on my old computer. When I try to run a data transformation on my new computer, it get almost no cputime or diskio when doing sp_who2 active. It run fine on my old machine. The error that eventually comes back is:

    Error Description: the number of failing rows exceed the maximum specified.

    Error writing file: the specified network name is no longer available.

    I also get a "Windows - Delayed Write Failed" error.

    It is as though the slow accumulate of diskio and cputime eventually leads to a network problem.

    Please help,

    Thanks

  • Also, transormations of 10k rows works but 1mm rows fails

  • Also, transormations of 10k rows works but 1mm rows fails

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply