Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 11th, 2007, 12:51 AM
Authorized User
 
Join Date: Oct 2004
Location: Bangalore, Karnataka, India.
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default Execute SSIS Package from ASP.NET

Hi,

I create one SSIS package to export data from a flat file, which is executing correctly through Visual studio.

My actual requirement is to execute this package from Asp.Net page.
So following C# code is using. After executing failure message is getting. Anybody can help on this?


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Application app = new Application();
        Package package = app.LoadPackage(@"C:\Projects\SSIS\AjSSIS\AjDTS.dt sx", null);
        DTSExecResult result = package.Execute();
        Response.Write(result.ToString());
    }
}

Thanks

Ghari :)




Similar Threads
Thread Thread Starter Forum Replies Last Post
Scheduling - SSIS package carumuga SQL Server DTS 0 October 10th, 2008 01:50 AM
How To Run SSIS Package uit VB How-To 4 August 12th, 2008 11:09 AM
SSIS - Package Configuration using Tables carumuga SQL Server 2005 0 July 17th, 2008 06:11 AM
Trigger SSIS package from Sharepoint pallavi11 SQL Server 2000 0 May 1st, 2007 05:33 PM
execute a package from ASP mdianep2p SQL Server DTS 2 July 19th, 2004 04:54 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.