Click here to Skip to main content
12,244,802 members (60,887 online)
Click here to Skip to main content
Articles » Web Development » ASP.NET » General » Downloads

Stats

171.9K views
5.2K downloads
97 bookmarked
Posted

Excecute SSIS package (DTSX) from ASP.Net

, 17 Sep 2008 CPOL
This article demonstrate the step by step procedure to create SSIS Package and Execute the same using ASP.net
SSIS_DEMO
BusinessTemplate.xls
Package1.dtsx
SSIS_Invoker
App_Data
BusinessTemplate.xls
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Execute SSIS</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        &nbsp;<div style="text-align: left">
            <table>
                   <tr>
                    <td style="height: 26px" colspan="2">
                   <h2>Execute SSIS Package</h2>     </td>
                </tr>
                <tr>
                    <td style="width: 100px; height: 26px">
                        <strong>
    
        Business ID</strong></td>
                    <td style="width: 100px; height: 26px">
                        <asp:TextBox ID="txtBusinessID" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td style="width: 100px">
                        <strong>BusinessName</strong></td>
                    <td style="width: 100px">
                        <asp:TextBox ID="txtBusinessName" runat="server"></asp:TextBox></td>
                </tr>
                   <tr>
                    <td style="width: 100px">
                        <strong>Upload Excel</strong></td>
                    <td style="width: 100px">
    
        <asp:FileUpload ID="FileUpload1" runat="server" /></td>
                </tr>   <tr>
                    <td style="width: 100px">
        </td>
                    <td style="width: 100px">
        <asp:Button ID="btnExecute" runat="server" Text="Execute SSIS" OnClick="btnExecute_Click" /></td>
                </tr>
            </table>
        </div>
    
        <br />
        &nbsp;&nbsp;<br />
        &nbsp;<br />
        <br />
        </div>
    </form>
</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

santosh poojari
Technical Lead
India India
Whatsup-->Exploring--> MVC/HTML5/Javascript & Virtualization.......!
www.santoshpoojari.blogspot.com

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160426.1 | Last Updated 17 Sep 2008
Article Copyright 2008 by santosh poojari
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid