How to execute a stored procedure with temp tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to execute a stored procedure with temp tables

Hi, Server A — SQL Server 2000
Server B — SQL Server 2005 I need to move data from source A to Source B using SSIS package in server B. I have a stored procedure in server A, in which I used private temp tables for processing data. I want to execute the SP through OLE DB source (which is part of data pump). I am getting error "invalid object name #temp1". Can someone help me in overcoming this problem. Thanks,
You should set the RetainSameConnection property of the connection to True. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

FYI…edures-inside-an-OLE-DB-Source-component.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.