ASP.NET, C# and DTS newbie question

#1

based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

#2

It is a bit diffcult to tell what might be wron from your brief descrption,
and without and error message, but a good guess woudl the security. By
default you will be running under the Machine\ASPNet account, so does this
have permissions to load and execute the package?

"Guy Dillen" <guy_dillen (AT) hotmail (DOT) nospam.com> wrote

Quote:

based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

#3

I am no ASP.NET expert but what is the error you are getting?

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-2004 All rights reserved.

"Guy Dillen" <guy_dillen (AT) hotmail (DOT) nospam.com> wrote

Quote:

based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

#4

obviously the ASP.NET app finds the package (which is in a dts file not in
the database), but doesn't execute it. Everything runs on 1 dev machine.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:

It is a bit diffcult to tell what might be wron from your brief
descrption,
and without and error message, but a good guess woudl the security. By
default you will be running under the Machine\ASPNet account, so does this
have permissions to load and execute the package?

"Guy Dillen" <guy_dillen (AT) hotmail (DOT) nospam.com> wrote in message
news:415340a5$0$11669$ba620e4c (AT) news (DOT) skynet.be...
based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

#5

From the ASP.NET app side the system doesn't give any error message, only
the app doesn't execute the package, although it finds the package (since
when trying to give the package a name that doesn't exist the ASP.NET app
gives an error message on that).

Guy

"Gert E.R. Drapers" <GertD (AT) SQLDev (DOT) Net> wrote

Quote:

I am no ASP.NET expert but what is the error you are getting?

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-2004 All rights reserved.

"Guy Dillen" <guy_dillen (AT) hotmail (DOT) nospam.com> wrote in message
news:415340a5$0$11669$ba620e4c (AT) news (DOT) skynet.be...
based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

#6

Most likely this is caused by a security problem. ASP.NET launches in a
different security context which might not be able to load the package; or
write the package to %TEMP% storage; or if you are using Windows
Authentication for one of your connections inside the package that might not
have a login or sufficient rights on your database.

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-2004 All rights reserved.

"Guy Dillen" <guy_dillen (AT) nospam (DOT) hotmail.com> wrote

Quote:

From the ASP.NET app side the system doesn't give any error message, only
the app doesn't execute the package, although it finds the package (since
when trying to give the package a name that doesn't exist the ASP.NET app
gives an error message on that).

Guy

"Gert E.R. Drapers" <GertD (AT) SQLDev (DOT) Net> wrote in message
news:e6qlNtgoEHA.800 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
I am no ASP.NET expert but what is the error you are getting?

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-2004 All rights reserved.

"Guy Dillen" <guy_dillen (AT) hotmail (DOT) nospam.com> wrote in message
news:415340a5$0$11669$ba620e4c (AT) news (DOT) skynet.be...
based on the exaple of theCookbook for using SQL Server DTS with .NET i
tried the example with ASP.NET. But this doens't seem to work? If thta's
right, why is that?
With a console app or winform app the same DTS app works fine.

Guy

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

ASP.NET, C# and DTS newbie question

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

ASP.NET, C# and DTS newbie question - 09-23-2004 , 04:31 PM

Re: ASP.NET, C# and DTS newbie question - 09-24-2004 , 02:15 AM

Re: ASP.NET, C# and DTS newbie question - 09-24-2004 , 02:51 AM

Re: ASP.NET, C# and DTS newbie question - 09-24-2004 , 02:53 AM

Re: ASP.NET, C# and DTS newbie question - 09-24-2004 , 02:55 AM

Re: ASP.NET, C# and DTS newbie question - 09-27-2004 , 05:40 AM