dts cancelled

Question

dts cancelled

sunshine

SSChasing Mays

Points: 636
More actions
November 12, 2003 at 11:17 am

#81457

I have a dts package that calls several other packages using the Execute Package task. I haven't made any recent changes to any of the packages (since July). In the past month, I'm getting the message 'Execution cancelled by user' when I attempt to run the package as a whole or when I run the Execute Package Task steps individually. I can execute the packages themselves sucessfully so long as I don't attempt to run them from an Execute Package Task. I'm on Sql 2000, SP3. Any ideas?
November 18, 2003 at 8:00 am

This was removed by the editor as SPAM

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

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Maybe this:

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=uIBxGNUvAHA.2028%40tkmsftngp04&rnum=1&prev=/groups%3Fq%3Ddts%2B%27Execution%2Bcancelled%2Bby%2Buser%27%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3DuIBxGNUvAHA.2028%2540tkmsftngp04%26rnum%3D1

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=0e1e01c25e6b%24d45b2590%2436ef2ecf%40tkmsftngxa12&rnum=7&prev=/groups%3Fq%3Ddts%2B%27Execution%2Bcancelled%2Bby%2Buser%27%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0e1e01c25e6b%2524d45b2590%252436ef2ecf%2540tkmsftngxa12%26rnum%3D7

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

sunshine SSChasing Mays Points: 636 More actions · Answer 2

Thanks for the links. I failed to mention that I'm running this straight from EM - no homegrown application interface code such as VB involved. I looked in disconnected edit but found no OnQueryCancel property anywhere.