Re: How to call an SSIS package from ASP.NET 2.0?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jun 7, 5:48 pm, Michael <missisum...@xxxxxxxxxxxxxxxx> wrote:
Hi,
I need to call an SSIS package from ASP.NET 2.0 web page. First I triy to
call it directly from the asp.net page, as the following:
Dim app As New Application
Dim pack As Package = app.LoadPackage("C:\GetNorthwindEmployee.dtsx",
Nothing)
Dim result As DTSExecResult = pack.Execute()

This fails although the same code in Windows app works. I think it's a
security rights issue so I give the full control right to the dtsx file and
set the system administrator for the anonymous access for the concerned
website in IIS (for testing purposes) but it still doesn't work.

Then I try to call the exe file from the the web page. I used to be able to
do this with VS2003,
Shell("C:\VS2005\RunSSIS\RunSSIS\bin\Release\RunSSIS.exe", AppWinStyle.Hide,
False)
but with VS2005, this stopped working.

Can anyone help me on this?

Thanks,

Hi Michael

try to capture SQL error as per example
http://msdn2.microsoft.com/en-us/library/ms136090(SQL.90).aspx

Cheers

.

Relevant Pages

  • Re: Sending email with attachments
    ... Give it a valid username and password. ... Private Sub SendEmail(ByVal Path As String, ByVal Too As String, ... Dim SendMessage As New SmtpClient ... Dim App As Attachment ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Sending email with attachments
    ... Private Sub SendEmail(ByVal Path As String, ByVal Too As String, ... Optional ByVal Body As String = "") ... Dim SendMessage As New SmtpClient ... Dim App As Attachment ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Sending email with attachments
    ... Private Sub SendEmail(ByVal Path As String, ByVal Too As String, ... Optional ByVal Body As String = "") ... Dim SendMessage As New SmtpClient ... Dim App As Attachment ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Sending email with attachments
    ... Private Sub SendEmail(ByVal Path As String, ByVal Too As String, ... Optional ByVal Body As String = "") ... Dim SendMessage As New SmtpClient ... Dim App As Attachment ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Cant create application in Authorization Manager
    ... > I've tried this in C# and also in a basic VBScript on two different ... The first machine is ... > Dim AzMan ... > Dim App ...
    (microsoft.public.platformsdk.security)