阅读背景:

SSIS Excel到SQL导入 - 该文件的前6行包含与标题相关的信息

来源:互联网 

I am working on importing thousands of rows(120K) of data from an excel file into a SQL Server. Now I am trying to use SSIS to accomplish this but I immediately ran into some problem considering the excel template that the excel file is built with does not seem to contain the Header in just the first row(about the first 6 rows contain header information). How do I solve for this problem using the SSIS Data flow task in BIDS to handle the imports? Or would it be better to read the lines via direct read of each row from the Excel document? I am working on importing thousands of rows(120




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: