UsingTemptableinSSISpackage-创新互联

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

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://www.xwwzsj.com/article/djshjo.html

宣威网站建设

UsingTemptableinSSISpackage-创新互联

其他资讯

联系我们

135-1821-9792

028-86922220

快捷导航

二维码

友情链接交换友情链接

宣威网站建设

UsingTemptableinSSISpackage-创新互联

其他资讯

联系我们

135-1821-9792

028-86922220

快捷导航

二维码

友情链接 交换友情链接

友情链接交换友情链接