存储过程很简单
ALTER PROCEDURE [dbo].[test]
AS
BEGIN
SET NOCOUNT ON;
create table #aaa
(
HotelId varchar(200)
)
select HotelId from #aaa a
END
但在SSIS调用的时候报错,求救,RetainSameConnection已经设置为True
...全文
3402打赏收藏
SSIS中调用带有临时表的存储过程报错,求救~~~
存储过程很简单 ALTER PROCEDURE [dbo].[test] AS BEGIN SET NOCOUNT ON; create table #aaa ( HotelId varchar(200) ) select HotelId from #aaa a END 但在SSIS调用的时候报错,求救,RetainSameConnection已经设置为True