Hi,

I'm using the following code to execute a DTS package from .NET:

http://support.microsoft.com/?kbid=319985

However when I run my package from ASP.NET, only the OnQueryCancel event
seems to fire. The OnProgress and OnError events do not fire. If I cause
an error on purpose, a COMException is thrown.

I would really like to handle the OnProgress and OnError events. Can
somebody please tell me if there is a way to get these to work.

Thanks,

Nick...

Hello Nick,

Whenever I want to fire a package from .Net and get some of the funky stuff
back I head over to Gert's site and he generally has something I need. Maybe
it will help you

www.SQLDEV.net


Allan

Hello Allan,

First, I'd like to confirm if the issue occurs for all DTS package. Also,
I'd like to know if you rasise OnProgress event in the custom task

http://msdn.microsoft.com/library/de...us/dtsprog/dts
pcust_4ror.asp

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
microsoft.public.sqlserver.dts:63187

I'm not sure I'm using a "custom task". I just created the DTS package
manually by creating Data Transform tasks and workflow steps. I do get
progress when I execute it manually from within enterprise manager.

Nick...

Hello Nick,

I tried to reproduce the issue on my side and I was not able to reproduce
the issue with the following steps:

1. Create a simple DTS job to import data from a excel file to a SQL table.

2. Create a .net console project in VS.net 2003.

3. Add the refer to Microsoft DTS Microsoft DTSPackage Object Library
version 2.0 COM object

4. Use the class ExecPkgWithEvents to replace the class created by VS.net

5. Change the server name to localhost, and DTS package name to test2 ( my
test package name)

package.LoadFromSQLServer("PNXDEVBOX", null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnection, null,
null, null, "Test", ref pVarPersistStgOfHost);

package.LoadFromSQLServer("localhost", null, null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnection, null,
null, null, "Test2", ref pVarPersistStgOfHost);

6. Build and execute the package and I could see the following events log
written into command prompt window in sequence:

onStart
onQueryCandel
OnProgress
OnQueryCancel
OnFinish
OnQueryCancel

I suggest that you try this step on a simple DTS package and then on a
different machine with VS.net installed to narrow down the issue.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------