Hi

This post is too old but just to add information so it can be helpful for others.

I faced same issue and by just trying i got the solution...

now its working ....

thanx dude... 😀

I am using PUBLIC role ........ (but I don’t think it should effect on creating temp table )

That quotes are not of any use , I forget to remove from post. Sorry 🙂

The full error msg as follow

TITLE: Microsoft Visual Studio

------------------------------

Error at Data...

i am runnig create , insert, select as single oledb darasourse cmd.

Actually i tried same without this also ...

That time i was able to run SSIS packed only once..

When i...

IF EXISTS (SELECT TOP 1 *

FROM Tempdb.dbo.sysobjects (nolock)

WHERE name LIKE ''##TUser%'')

DROP TABLE ##TUser

CREATE TABLE ##tuser( [instance_name] [nvarchar](128) NULL,db_name [nvarchar] (128) null,[name] [sysname] NULL,[owner_name] [nvarchar](128) NULL,[type] [nvarchar](60) NULL,[create_date] [datetime] NULL,[modify_date] [datetime]...

and one more thing

in this case if i go to run packed again then i think it will throw error .. " ##tuser is already exsit"

i tryed without @cmd and execute ..

now i am getting error at the time of validation itself...

error msg " invalid object##tuser"

...

i already RetainSameConnection property as ture...

can you please describe your answer with the help of sample code

i am doing all task in one shot..

i not mantion the insert step.

set @cmd1='insert into ##tuser select @@servername as instance,db_name() as db_name,name,schema_name(schema_id) as owner_name,type_desc,create_date,modify_date,getdate() as date from sys.objects

then i...

invaled Object ##tuser

That i already test but still having same problam.