I have created a Stored procedure which is executing right in query
analyser but if i put the same stored procedure in the DTS to execute
,Data transformation task it is giving me error as
"ADO ERROR : Invalid Object Name #tempEmp "


In this stored procedure I have created Temporary table #tempEmp.
stored procedure is as follows ;

CREATE PROCEDURE EmpIDName
AS
begin transaction
create table #tempEmp (EmpId int, EmpName varchar(20))
insert into #tempEmp
SELECT EmpId , EmpName from Employee
select * from #tempemp
commit transaction

Please help me.
Thank you.

you can not use temp table in Data transformation tas. What you can to
is create the permant temp table and dump the data, do all your
manipulation.

Once the Process is over you can drop the permant temp table inside the
DTS package itself.


Dipa wrote: