Creating Global Variables

I wish I could set a global value on my project so this one value could be
used by each of my reports. Is it possible?Eric,
Global variables defined in your project isn't possible. But you can
consider to use the underlying datasource for this purpose. Just retrieve in
all your report a datasource with the 'global' variables. Be sure that you
put all your variables in one row and name the columns as your variablenames.
Jan Pieter Posthuma
"Eric" wrote:
> I wish I could set a global value on my project so this one value could be
> used by each of my reports. Is it possible?
>

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

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 Rajput
Hi
"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

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