Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unhappy Unanswered: dts ackage failing

    hi

    i have a dts package that runs fine in sql7.0 ,os win NT ,but the same dts fails in sql2000 Win2000 OS, with the following eror

    cursor opeartion couldnot be completed since the set options for the cursor have been changed since the cursor was last declared.

    please help.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Are you using global cursors ?

  3. #3
    Join Date
    Nov 2003
    Posts
    4
    yes

  4. #4
    Join Date
    Nov 2003
    Posts
    4
    yes

  5. #5
    Join Date
    Sep 2003
    Posts
    212
    make sure u 'close' or 'deallocate' ur cursors after usage otherwise it has sum undesirable effects

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •