470,573 Members | 1,663 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,573 developers. It's quick & easy.

DTS execution from dll

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
Nov 18 '05 #1
3 1148
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
"Suzanne Boyle" <su**************@NOSPAMyahoo.co.uk> wrote in message
news:OP**************@TK2MSFTNGP11.phx.gbl...
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

Nov 18 '05 #2
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.
"Allan Mitchell" <al***@no-spam.sqldts.com> wrote in message
news:eQ**************@TK2MSFTNGP09.phx.gbl...
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
"Suzanne Boyle" <su**************@NOSPAMyahoo.co.uk> wrote in message
news:OP**************@TK2MSFTNGP11.phx.gbl...
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


Nov 18 '05 #3
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

"Suzanne Boyle" <su**************@NOSPAMyahoo.co.uk> wrote in message
news:O7**************@TK2MSFTNGP12.phx.gbl...
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.
"Allan Mitchell" <al***@no-spam.sqldts.com> wrote in message
news:eQ**************@TK2MSFTNGP09.phx.gbl...
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
"Suzanne Boyle" <su**************@NOSPAMyahoo.co.uk> wrote in message
news:OP**************@TK2MSFTNGP11.phx.gbl...
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



Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Paolo Losi | last post: by
2 posts views Thread by Jenny Zhang | last post: by
5 posts views Thread by Johannes Lebek | last post: by
75 posts views Thread by Beni | last post: by
2 posts views Thread by Ina Schmitz | last post: by
2 posts views Thread by abhaybhat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.