DTS execution from dll

  • Thread starter Thread starter Suzanne Boyle
  • Start date Start date
S

Suzanne Boyle

Hi,

I am executing a DTS package from asp.net. It works successfully when the
code and PackageEventsSink class declaration is in the aspx file however
when the code is compilied into a dll I get the error 'Execution was
canceled by user'.

Does anyone have any ideas as to what the problem could be?

Thanks,

Suzanne
 
Are you using Events?

If you google on this message then you will see a response from Euan Garden
re: wherever you pass pbCancel ByRef then you must set it to False in the
event handler.

There are others who have had this error (JP) and have yet to find a
solution. I have yet to have it even with packages that fail on other
people's Servers.

I am always on the lookout for code that fails everytime

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
 
I am using events and do set the pbCancel to false in the OnQueryCancel
event handler.

I even tried re-creating the package to make sure no bugs had been compilied
into it as was mentioned in another post.
 
I've managed to narrow down the problem...

I have a transform data task that, when successful I want to run an execute
sql task however when I add the workflow OnSuccess flow between the
destination connection and the execute sql task running the package from
asp.net causes the 'Execution was canceled by user' error.

Anyone any ideas why this is happenning, its begginning to drive me round
the twist.

Suzanne
 
I got actually this 'rare' situation as well.

This is my situation:

My main DTS 1 is calling a sub DTS 2. When I run these manually or via SQL Agent it runs fine.

If I start to run DTS 1 via ASP the package fails. When I look at the log it sais 'Execution was canceled by user'.
If I start DTS 2 via ASP it runs fine....

Sounds like an issue to run in main thread.

My first question is, many people are saying that you have to run the sub DTS 2 in the main thread. But where can I change these settings (standard edition)? I can't find at workflow properties this setting. The only place I can find something is "Disconnected edit", at steps the setting "ExecuteInMainThread" which is a boolean. I have set this for each step to TRUE, but still no results.

Did somebody else nail down this problem?

I found another topic by Susanne but changing the workflow from "Succes" to "Completion" doesn't sound logical.

Thanx in advance!
Regards,
Esgar
 
I got actually this 'rare' situation as well

This is my situation

My main DTS 1 is calling a sub DTS 2. When I run these manually or via SQL Agent it runs fine

If I start to run DTS 1 via ASP the package fails. When I look at the log it sais 'Execution was canceled by user'
If I start DTS 2 via ASP it runs fine...

Sounds like an issue to run in main thread

My first question is, many people are saying that you have to run the sub DTS 2 in the main thread. But where can I change these settings (standard edition)? I can't find at workflow properties this setting. The only place I can find something is "Disconnected edit", at steps the setting "ExecuteInMainThread" which is a boolean. I have set this for each step to TRUE, but still no results. Could somebody explain clearly how to make this setting

Did somebody else nail down this problem

Changing the workflow from "Succes" to "Completion" doesn't sound logical

Thanx in advance
Regards
Esgar
 
Back
Top