I am creating a global temporary table by calling a stored procedure in one
of the steps in a DTS package. In another step, I am trying to fetch records
from the global temporary table. I am getting some errors here.
How to resolve this?


Regards,

Sevugan.C

Hi What is the error that you are getting

best Regards,
Chandra
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

Hi Sevugan

Sevugan wrote:
which errors do you get?
Are you sure you created a global temp table ;-)

Helge

Hi Helge,
It says invalid object name. Default prcedure could not be parsed.


--
Sevugan.C


"Helge C. Rutz" wrote:

Hi Chandra,
It says Invalid object name.
--
Sevugan.C


"Chandra" wrote:

Is the session active between 2 steps. The temporary table gets deleted when
the session is killed.

just try acessing the table by ##temptable

--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------



"Sevugan" wrote:

Hi,
I have created a temporary table with ##. I executed the step in the DTS
package. It said successfully executed. I looked up in the tempdb database
for the temporary table I have created in the previous step. It was not
available.
Is it possible to create a ##temporary table inside a DTS Package.
--
Sevugan.C


"Chandra" wrote:

Hi
I have created a emp table with the name ##TempTable
--
Sevugan.C


"Helge C. Rutz" wrote:

Hi Sevugan,

"Sevugan" <Sevugan (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:1CA43F66-30FA-4EDA-929F-1C9FCA723C0C (AT) microsoft (DOT) com...
You should be able to create temp tables, but there are some things to
consider.
1. The table is removed when the package finishes. If the connection is
resetted/closed during package execution the table is also gone.
2. Avoid to use temp tables in workflows where datapumps are inbetween,
because somtimes the connection is resetted by the datapump task which will
result in loss of temp table.
BTW: The table will get a dynamic name inside of the temp DB, so it's not
easy to find it from outside - do you know how to look for it?

Helge