UsingTemptableinSSISpackage-创新互联

My target is using SSIS to export the data into Excel file from SQL Command(OLB DB Source).

However. I created a very simple demo to testing the functionality as below(SQL query thing) but nothing can be export successful.

在网站制作、做网站中从网站色彩、结构布局、栏目设置、关键词群组等细微处着手，突出企业的产品/服务/品牌，帮助企业锁定精准用户，提高在线咨询和转化，使成都网站营销成为有效果、有回报的无锡营销推广。创新互联专业成都网站建设十年了，客户满意度97.8%，欢迎成都创新互联客户联系。

declare @Temptabletable (Id int, Name nvarchar(50))

insert into @Temptable values(1, 'name1')

insert into @Temptable values(2, 'name2')

select Id, Name from @Temptable

In 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

分享文章：UsingTemptableinSSISpackage-创新互联
文章分享：http://bjjierui.cn/article/djshjo.html