使用带有Asp.net C#的SSIS包将Excel数据导入SQL Server [英] Import Excel data to SQL Server Using SSIS package with Asp.net c#

问题描述

大家好，
我需要使用带有c#的asp.net将Excel数据导入SQL Server数据库.我正在使用文件上传控件上传excel数据，并使用带有c#的asp.net执行.dtsx包.为此，我创建了SSIS包MSBI，以将数据从excel导入到SQL Server，并进行了部署.然后，我开始在asp.net中使用.dtsx(package)将上载的Excel数据插入到SQL Server中.运行包时，记录将插入数据中.当我在我的机器上使用带有C#的asp.net执行程序包时，它运行良好，并且那些记录正在插入数据库中.在IIS应用程序服务器中部署和配置后，它将引发失败消息.如何使用c#在asp.net中使用SSIS包.在此先感谢...

问候，
Jeevan.

Hi All,
I have a requirement to import excel data to SQL Server database using asp.net with c#. I am uploading excel data using file upload control and executing .dtsx package using asp.net with c#. For that I have created SSIS package MSBI to import data from excel to SQL Server and i deployed it. Then i started using of .dtsx(package) in asp.net to insert uploaded excel data into the SQL server. When i run the package records are inserting into the data. When i am executing the package using asp.net with C# in my machine it is working fine and those records are inserting into the database. When deployed and configured in IIS application server then it is throwing failure message. How can use SSIS package in asp.net with c# . Thanks in an advance...

Regards,
Jeevan.

推荐答案

请看看:
使用SSIS将数据从Excel导入SQL Server [ ^ ]
使用SSIS 2005通过SQL Server数据动态生成Html/Excel/Word文档文件 [ ^ ]

Please have a look:
Import Data from Excel into SQL Server Using SSIS[^]
Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005[^]

这篇关于使用带有Asp.net C#的SSIS包将Excel数据导入SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！