扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
However. I created a very simple demo to testing the functionality as below(SQL query thing) but nothing can be export successful.
declare @Temptabletable (Id int, Name nvarchar(50))
insert into @Temptable values(1, 'name1')
insert into @Temptable values(2, 'name2')
select Id, Name from @TemptableIn terms of the that SQL Command OLB DB Source component couldn't output the result.
Finally. I found out the solution is that need to set the NOCOUNT to ON
SET NOCOUNT ONdeclare @Temptabletable (Id int, Name nvarchar(50))
insert into @Temptable values(1, 'name1')
insert into @Temptable values(2, 'name2')
select Id, Name from @Temptable
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
微信二维码
移动版官网