Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > DTS execution from dll

Reply
Thread Tools

DTS execution from dll

 
 
Suzanne Boyle
Guest
Posts: n/a
 
      01-22-2004
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


 
Reply With Quote
 
 
 
 
Allan Mitchell
Guest
Posts: n/a
 
      01-22-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>



 
Reply With Quote
 
 
 
 
Suzanne Boyle
Guest
Posts: n/a
 
      01-22-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >

>
>



 
Reply With Quote
 
Suzanne Boyle
Guest
Posts: n/a
 
      01-27-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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
> > >
> > >

> >
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Day! DTS Criterion DAZED & CONFUSED dvd, Ltbx THE SHADOW DTS LD, Criterion BOOGIE NIGHTS ld J Rusnak DVD Video 0 01-02-2007 11:30 PM
FA: DTS THE SHADOW ltbx LD, DTS DAZED & CONFUSED Crit. DVD, Criterion BOOGIE NIGHTS LD J Rusnak DVD Video 0 12-28-2006 05:30 PM
FA: DTS ANACONDA Superbit, Factory-Sealed DEEP RISING dvds, DTS CARLITO'S WAY ld J Rusnak DVD Video 0 04-11-2006 02:30 AM
The Jackal (1998) DTS vs non-DTS Aphelion DVD Video 2 04-07-2005 01:44 AM
Re: Matrix DTS and Matrix 2 DTS? PeterTHX DVD Video 0 08-03-2003 05:46 AM



Advertisments