saving the filename into sql database and running ssis package at the same time

[asoutiyal]

Scenario: I am developing a web application that allows users to upload excel files into their respective tables in MS SQL database 2008. I am also running an ETL process developed using SSIS when the user clicks on the upload button. My development environment: Asp.net, IIS7, C#, MS SQL Server 2008 R2Problem: I am currently facing the problem of saving the file name of the file into another column in the tables as I will also be creating gridview function for the user to view the files that have already been uploaded into the database and enables the users to download the error files.Question: Are there any ways I can save the file name into the same tables while running the SSIS packages during the ETL process?Below are a sample example of my codes:\[code\]string filePath1 = Server.MapPath(System.IO.Path.GetFileName(file.FileName.ToString())); file.SaveAs(filePath1); package = app.LoadPackage(packageString, null); package.Connections["Excel Connection Manager"].ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath1 + ";Extended Properties=Excel 12.0;HDR=YES;IMEX=1"; Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();\[/code\]This method allows me to retrieve the fileName :\[code\]String.Format("File : {0} uploaded.", file.FileName)\[/code\]So when i execute the package, how do i save the file name to the tables at the same time?