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 |
|
gunjan.sh@gmail.com
Starting Member
1 Post |
 Posted - 2008-01-03 : 00:38:37
|
| Hi,In my script 'm usingSet oPkg = DTSGlobalVariables.ParentSet oBeginStep = oPkg.Steps("DTSStep_DTSExecuteSQLTask_1")I guess becoz of using DTSGlobalVariables.Parent in activex,the script is not working.Can anyone please suggest a solution to run it in SSIS.Thanks in Advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-07 : 09:59:59
|
| Try accessing like this:-Dts.Variables(”Parent”).Value |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-01-16 : 08:57:14
|
| Sorry, is there a reason to stick with ActiveX Script? It's easier to drag SQL Task nowadays. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-16 : 09:06:26
|
quote:
Originally posted by rgombina
Sorry, is there a reason to stick with ActiveX Script? It's easier to drag SQL Task nowadays.
You didnt specify what action you need to perform. Your question was how to remove error in accessing variable in activex script. Thats what i've replied for. You can very well use SQL task if you believe it can provide you soln for your problem. Can you tell what are you trying to achieve in your package? |
|
|
|
|
|
|
Activex Script not working after migrating to SSIS