SQL命令未返回列信息（SSIS中的Excel源） [英] No column information was returned by the SQL command ( Excel Source in SSIS)

问题描述

大家好，



我正在使用SQL命令从 Excel Source读取数据：



从[Tabname $ B10：E25]中选择*
$


但我收到以下错误：
$


标题：Microsoft Visual Studio

-------------------- ----------
$


该组件报告了以下警告：



错误在数据流任务[OLE DB源[1]]：SQL命令没有返回列信息。

Hi All,

I am reading data from Excel Source using SQL command like below :

Select * from [Tabname$B10:E25]

But I am getting following error :

TITLE: Microsoft Visual Studio
------------------------------

The component reported the following warnings:

Error at Data Flow Task [OLE DB Source [1]]: No column information was returned by the SQL command.

我看过几个要使用的帖子  SET FMTONLY OFF但如何在excel源中使用它。

I have seen couple of post to use SET FMTONLY OFF but how to use it within excel source.

推荐答案

范围包含什么？

what does the range contain?

是否包含列标题的正确数据？

Does it have proper data with column headers?

这篇关于SQL命令未返回列信息（SSIS中的Excel源）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！