Uplading Files Dynamically Using SSIS

Tue May 15, 2012 5:34 am

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

Wed May 16, 2012 12:30 am

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

Uplading Files Dynamically Using SSIS

Uplading Files Dynamically Using SSIS

Re: Uplading Files Dynamically Using SSIS

Topic Tags