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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2009-01-12 : 04:00:56
|
| Hi Pals,Need some urgent help.Inside my SSIS PACKAGE , declared a global variable with name as "Obj" whose datatype is of "Object" datatype and is getting used inside a Foreachloop container.One more variable "param_4" which is used to assign a value inside a Foreachloop container.Also having other 3 other variables of "String" dataype. I am calling this package from a stored procedure. I have a question here. Cant we set a value for a variable whose datattype is "Object"?SQL Command :"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /F "D:\PackageStore\Package.dtsx"/SET "\Package.Variables[User::param_1].Properties[Value]";"101"/SET "\Package.Variables[User::param_2].Properties[Value]";"2008JanuaryVersion1.1"/SET "\Package.Variables[User::param_3].Properties[Value]";"01023"/SET "\Package.Variables[User::Obj].Properties[Value]";""/SET "\Package.Variables[User::param_4].Properties[Value]";""And when i execute this package at DOS prompt, am getting the below error.Argument ""\Package.Variables[User::Obj].Properties[Value];"" for option "set" is not valid.Note :: Scope of all the variables are set to "Package level".What i have done is i commented the last 2 lines of code and re ran the command.This time it is getting executed very fine. My doubt is , what could be problem if i seta variable of "Object" datatype. IS is there any limitation for this or else is there any particular limitations or hard fast rules for variables being used inside the ForEachLoopContainer.Any thoughts?????Any help would be appreciated.Thank You! |
|
|
|
|
|
Issue with Global Parameters!!!