Executing DTS package in c#

#1

I'm trying to execute a dts package (as file) in AspNet (C#) as per the
http://sqldev.net site tut.
It works fine when running it in SQL and I get the results as expected.
However in AspNet it runs through
the code but does not do anything in the dts package itself. ie: stepping
through it seems fine,
no exceptions, but nothing happens on the SQL side.

Any ideas??

#2

Probably caused by the security context of the ASP.NET work process.

GertD (AT) SQLDev (DOT) Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"Francois" <fraste (AT) iafrica (DOT) com> wrote

Quote:

I'm trying to execute a dts package (as file) in AspNet (C#) as per the
http://sqldev.net site tut.
It works fine when running it in SQL and I get the results as expected.
However in AspNet it runs through
the code but does not do anything in the dts package itself. ie: stepping
through it seems fine,
no exceptions, but nothing happens on the SQL side.

Any ideas??

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Executing DTS package in c#

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Executing DTS package in c# - 10-10-2005 , 07:41 AM

Re: Executing DTS package in c# - 11-13-2005 , 11:27 PM