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.
| Author |
Topic |
|
BhaskarDasari
Starting Member
19 Posts |
 Posted - 2008-03-19 : 07:01:57
|
| can i create the variable with scope --Project |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-03-24 : 07:12:11
|
| i want to create a variable with scope project But not package.when we create variable we are asked to enter name,scope(automatically be visible as "package name"),value.If scope is package then that variable wont be available for other packages.But i have to reuse the same variable in many packages.Is there any way of doing that. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-24 : 09:12:56
|
| Create one parent package that will feed the variable values to the child packages. |
|
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-03-25 : 00:50:36
|
| can you explain me in detail how can i feed the values to the child packages |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-03-25 : 09:17:34
|
| You must first be familiar with the Parent/Child concept, basically you create a Parent SSIS package that will control and pass values to all your child packages.I recommend you doing some reading on this before trying to implement.http://msdn2.microsoft.com/en-us/library/ms345179.aspx |
|
|
|
|
|
|
can i create the variable with scope --Project