temp tables in stored procedures called from dts package

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: matthew c. harad (matthewcharad_at_discussions.microsoft.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 10:47:02 -0700

i'm calling a stored procedure to generate a dataset for importation across
sql servers. the stored procedure uses a temp table. when trying to set up
the dts package, i get an error message "invalid object #temptablename"

what's going on here? can i just not use temp tables in sp's that get
called from dts packages? is there a standard workaround? or am i just
doing something wrong?

thanks
matthew

Relevant Pages

  • Re: temp tables in stored procedures called from dts package
    ... dts package because it is created and dumped once the ... Is there some connection property to use to hold open the ... the stored procedure uses a temp table. ...
    (microsoft.public.sqlserver.dts)
  • Re: temp tables in stored procedures called from dts package
    ... just before I design the package so that it know about it and can do all the ... > i'm calling a stored procedure to generate a dataset for importation> across ... the stored procedure uses a temp table. ... > the dts package, i get an error message "invalid object #temptablename" ...
    (microsoft.public.sqlserver.dts)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedures in SE 7.3
    ... My end goal to write a stored procedure to be used by Lotus Enterprise ... Integrator (LEI). ... into temp t1; ... from bmdata, t1 ...
    (comp.databases.informix)
  • RE: Strange issue while executing sql server sp
    ... field is the one where truncation is occurring as my temp table field size is ... I have a simple stored procedure in sql server 2005 express version. ... ,finishdate datetime ...
    (microsoft.public.sqlserver.programming)