Creating Global Temp table in sql 2005 DTS

Hi All,
I want to use temp table created in one step to be used in other
step.
How can i do that ?
I tried this..
One step : Create table ##abc (Fileid Int)
Other Step : Select * from ##abc -- When i Parse the query it is
giving error Invalid object name ##abc
Can anyone help me with this ?
Regards,
Rajeev RajputHi
"Rajeev" wrote:
> Hi All,
> I want to use temp table created in one step to be used in other
> step.
> How can i do that ?
>
> I tried this..
>
> One step : Create table ##abc (Fileid Int)
>
> Other Step : Select * from ##abc -- When i Parse the query it is
> giving error Invalid object name ##abc
>
> Can anyone help me with this ?
>
> Regards,
> Rajeev Rajput
>
Assuming that you have set up the correct presedences and the two tasks are
sharing the same connection, then make the RetainSameConnection property to
true on the connection and it should be ok.
John