将文件的大容量上载插入到mssqlserver2005中 [英] inserting of Bulk upload of files in to mssqlserver2005

问题描述

我有一个包含100个文件的文件夹，每个文件包含以``|(管道)''分隔的列，并且类似地，该文件也包含数据.
因此，我需要将该文件夹批量上传到ms sqlserver2005，以便自动将这些表与数据添加到数据库中，以便如何做?
告诉我是否有可用的存储过程或任何asp.net程序！

Hi,

i am having a folder which contains 100 files and each file contain the columns separated by the '' |(pipeline)'' and similarly that file contain data also.
so i need to bulk upload this folder to the ms sqlserver2005 so that automatically these tables with data added in the database so how to do that one?
tell me if any store procedure or the any asp.net program is available for that!

推荐答案

msdn.microsoft.com/zh-我们/library/ms188365.aspx

使用DTS和SSIS....您可以非常轻松地使用它....
计划该程序包，以便它将自动获取文件(设置所需的频率)
我们在做同样的事情...

谢谢

use DTS od SSIS....you can do it very easily with it....
Schedule that package sothat it will automatically get the files (set the frequency u want)
We are doing the same...

Thanks

这篇关于将文件的大容量上载插入到mssqlserver2005中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！