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 |
|
TabAlleman
Starting Member
8 Posts |
 Posted - 2008-09-08 : 11:08:49
|
| I have a SSIS package that may be run as a child, or on its own. When it is run as a child, it will use variables from the parent, but when it is run as a standalone, those variables will not exist. I want to check in a script task whether the parent variables are present, but I can't find anything on how to do this, and my best guess (below) doesn't work. It returns the "variable does not exist" error:If Not IsNothing(Dts.Variables("ParentStart").Value) Then...-Tab Alleman |
|
|
TabAlleman
Starting Member
8 Posts |
Posted - 2008-09-08 : 11:59:32
|
| I found it:If Dts.Variables.Contains("ParentStart") = True ...-Tab Alleman |
 |
|
|
favaz.farook@gmail.com
Starting Member
8 Posts |
Posted - 2008-09-12 : 12:27:05
|
| The variable not found means you have not specified the variable in the script task properties "ReadOnlyVariales" or "ReadWriteVariables" |
|
|
|
|
|
|
Script Task - Check if Variable exists