Hi there,
lately I had the following message on win2000 sp4 with sqlserver2000 sp3a: "DTS Designer Error - Specified file not found".
Then in the DTS editor the Task menu objects are missing and it is not possible to link a source and a target using Transform Data Task.
Before it used to work fine.
I have done the following:
- installing again last sp: same issue again
- reinstalling sqserver with a registry deep cleaning: same issue again
- started disabled windows services: same issue again
any idea?
Carsten
edit:
Could it be possible that a lately installed fix for Win2K interferes with DTS-Designer?Finally found a solution for this problem!
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=112035
Showing posts with label win2000. Show all posts
Showing posts with label win2000. Show all posts
Thursday, March 22, 2012
Friday, March 9, 2012
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.Are you using global cursors ?|||yes|||yes|||make sure u 'close' or 'deallocate' ur cursors after usage otherwise it has sum undesirable effects
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.Are you using global cursors ?|||yes|||yes|||make sure u 'close' or 'deallocate' ur cursors after usage otherwise it has sum undesirable effects
Subscribe to:
Posts (Atom)