Click here to Skip to main content
12,747,719 members (40,434 online)
Click here to Skip to main content
Articles » Web Development » ASP.NET » General » Downloads

Stats

186.9K views
5.5K downloads
102 bookmarked
Posted 24 Jul 2008

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...

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