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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-25 : 10:39:42
|
| Vijay krishna writes "I am trying to change the values of global variables using execute process task. It is working fine with a globalvariable,which is assigned to a connection(Datasource property for excelConnection), using dynamic properties task. But it is not working for other global variables, which I want to change using execute process task. Please help me, My code part is here. Note that I had tried out both in C#.NETand VB.packageHR.GlobalVariables.Remove ("PackageFilePath")packageHR.GlobalVariables.AddGlobalVariable "PackageFilePath", txtFileName.TextpackageHR.GlobalVariables.Remove ("ExcelSheet")packageHR.GlobalVariables.AddGlobalVariable "ExcelSheet",SheetName packageHR.GlobalVariables("LocationID").Value = CInt(LocationID)It's working fine with "packageFilePath" but failing for other two. Among them "LocationID" is int and others are string. If any thoughts..........Thanks in advance." |
|
|
|
|
|
DTS