通过自定义查询错误导入表 [英] Importing table via Custom Query Error

问题描述

在构建表格模型时，我基于一系列选择Insert Into表导入表。

在Custom SQL查询窗口中，我提交了我创建的查询3临时表，填充临时表，从临时表中选择，然后继续删除临时表。 
$


查询在SSMS中成功运行，但是Visual Studio，当我输入查询并单击"验证"时错误消息"无效的对象名称'TempTable1"出现。 
$


我做错了什么吗？如何在表格模型中选择加载？ 

解决方案

共享查询或屏幕截图。确保在查询中使用数据库。

In building my tabular model, I am importing tables based on a series of select Insert Into tables.

Within the Custom SQL query window, I submit my query which creates 3 Temp tables, populates the temp tables, selects from the temp tables, then proceeds to drop the temp tables. 

The query works successfully in SSMS, however in Visual Studio, when I enter the query and click "Validate" the error message "Invalid object name 'TempTable1" appears. 

Am I doing anything improperly? How can I get select to load within my tabular model? 

解决方案

share query or screenshot .Make sure that database is used in query.

这篇关于通过自定义查询错误导入表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！