Re: DTS Through ASP Page permissions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the ideas.

I will give them a try this week and let you know how it turns out.

I am running an asp page calling the stored proc. I was hoping there
was a way to have the asp page receive the error if it happened. I may
have to capture the log file and display it or a portion somehow on
the page.

Thanks,

Tim

On Jan 27, 12:00 pm, "tbradshaw via SQLMonster.com" <u12692@uwe>
wrote:
Hello Tim,

Russell has good advice.  You also asked about returning an error.  To where?

I have never tried to execute a package from within a stored procedure, but
when I execute a package from a SQL Agent job using DTSRUN, the job will
report failure when there is a failure within DTS.  So, perhaps on the next
line following your DTSRUN, you could check @@ERROR for success/failure.
Likewise you could throw an exception up the call chain back to your ASP page.

In addition, you can capture your DTS execution in a log file.  In the
designer window, right-click on an empty space & choose "package properties".
In the logging tab, you can log to either SQL server or to an error file.
For simplicity, I log to Error File by providing a path to a text file.

Fair Warning:  Logging appends data to the file for each run, so you'll need
some outside process to empty it from time to time.

Let us know how you make out.

Regards, Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer

--
Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200901/1

.

Relevant Pages

  • ASP ADO SP call returning closed recordset
    ... This was originally posted to comp.databases.ms-sqlserver, but no response ... Can anybody tell me why a) when running a stored proc from an asp page to ... 'execute the SP returning the result into a recordset ...
    (microsoft.public.sqlserver.programming)
  • Re: IIS 5.1 execution questions - application failed to initialize
    ... The identity used by IIS to execute ASP page (and hence your WshShell.Run ... negotiated between the client and IIS in accordance to IIS authentication ...
    (microsoft.public.inetserver.iis)
  • Re: using "Wscript.Shell" in asp
    ... Enable authentication and disable anonymous access to the ASP page ... I want to use the "dtsrun" command in an ASP page. ... When i execute the page, i get no error, but the dtsrun does not seem ...
    (microsoft.public.scripting.wsh)
  • How execute DTS from a ASP
    ... I have found the script that allow to execute the DTS from asp but I have a ... Dim oPkg, oStep, sErr, bSuccess ...
    (microsoft.public.sqlserver.dts)
  • Global Objects
    ... I'm a PHP programmer who has been hired by a company to do web ... I would execute a command something like this: ... // Then I would be able to execute commands something like this: ... in ASP .NET I know there is a Global.asax file that you create ...
    (microsoft.public.dotnet.framework.aspnet)