asked
Browse an excel file through .NET application and upload to sql server via SSIS package
Hi All, I am SQL DBA cum IIS admin. Currently, we are using SQL Server 2012 in our organization. There is a .NET application(MVC) from where end users use upload data from excel to sql server. We are facing issue with this upload since we are uploading huge volume of data through excel(Microsoft Data access component throws error because of huge data). As an alternate, we are planning to go for SSIS package. Is it possible to browse an excel file(located at user's desktop) through web application and upload it to SQL Server via SSIS package. Thanks in advance, K.P.Senthil Kumar
so you have excel file which gets data from .net application and then you want to dump that in sql database? If yes its very much feasible since you could specify the path in ssis package using excel source.
But, as I said, the excel files are uploaded from End users' desktop. Do we need to create the folder path on all the computers from where the files are uploaded?. This could be a silly question since I am new to SSIS.
In that case you could try to set up a centralised location where users could dump files and ssis package picks up Or else as you said for each file you need to specify path
18 People are following this question.
