Uplading Files Dynamically Using SSIS

Rock

I have a requirement to upload excel data (from .aspx) to the SQL server. To do this I am implemented using SSIS. I have created SSIS package(deployed) and executing it using c#. When i am running the application it is working fine inserting data into the database.After this we just want to Upload file Dynamically using File Upload Control.Please Provide Coding For this Requirement

DrRakha

What i understood that you need to upload file (excel file ) using ASP.NET, following ASP.NET using visual basic. Following ASP.NET 2 :

Code:

<%@ Page Language="VB" %>

<script runat="server">
    Protected Sub FunUploadFile(ByVal sender As Object, _
      ByVal e As System.EventArgs)
        If UploadParam.HasFile Then
            Try
                UploadParam.SaveAs("C:\Temp\" & _
                   UploadParam.FileName)
                msgLabel.Text = "Name: " & _
                   UploadParam.PostedFile.FileName & "<br>" & _
                   " Size: " & _
                   UploadParam.PostedFile.ContentLength & " kb<br>" & _
                   "Content type: " & _
                   UploadParam.PostedFile.ContentType
            Catch ex As Exception
                msgLabel.Text = "err: " & ex.Message.ToString()
            End Try
        Else
            msgLabel.Text = " No file specified...."
        End If
    End Sub
</script>

<html >
<head runat="server">
    <title>Upload Files</title>
</head>
<body>
    <form id="myForm" runat="server">
    <div>
        <asp:FileUpload ID="UploadParam" runat="server" /><br />
        <br />
        <asp:Button ID="Button1" runat="server" OnClick="FunUploadFile" 
         Text="Upload File" />&nbsp;<br />
        <br />
        <asp:Label ID="msgLabel" runat="server"></asp:Label></div>
    </form>
</body>
</html>

and this generate html code as :

Code:

<html >
<head><title>
   Upload Files
</title></head>
<body>
    <form name="myForm" method="post" action="fileUpload.aspx" 
     id="myForm" enctype="multipart/form-data">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="Genereted Value" />
</div>

    <div>
        <input type="file" name="UploadParam" id="UploadParam" /><br />
        <br />
        <input type="submit" name="Button1" value="Upload File" 
         id="Button1" />&nbsp;<br />
        <br />
        <span id="Label1"></span>
    </div>
    
<div>

   <input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" 
    value="Genereted Value" />
</div></form>
</body>
</html>
 

When this code run, the user select a file to upload, as you notice that the destination folder is determined at the ASP code. Please note that the destination folder writing permissions should be set correctly. You may notice that “FileUpload” control element in VB was converted to <input type…> HTML element.

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

Uplading Files Dynamically Using SSIS

Topic Tags