Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 scope of variable

Author  Topic 

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2007-12-04 : 03:37:52
Hi,
Is there any way to change the scope of a user defined variable?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 03:41:08
In what way?

You can pass a variable as a parameter to another SP or function.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2007-12-04 : 04:00:20
To change the scope from package level to dataflow level or vice versa...
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-04 : 04:10:07
You are talking about SSIS, right?
Please post in DTS/SSIS forum.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -