Hi,
How to access the Package inside the Script Taks. for example
IF intStatus = 1 Then
//Execute Package1
Else
//Execute Package2
End IF
in the above sample what is the property to get the Package1 object in script
Thanks & Regards
Jegan.T
You should use the Execute Package Task in order to execute other packages. Any reason why this doesn't work for you?
-Jamie
|||If i use Execute Package i have to supply all the connection string details.we have the requirement is like this we have to excute the package based on a routine or function execution .its more like using batch file in Data Stage.
Jegan.T
|||Sorry, I don't know anything about DataStage.
The connection string for the package tells you where it is located. Surely you need the same information in order to execute from the Script Task?
-Jamie
|||Hi Jamie
Thanks for your reply . but the Script Task does not have any provison for connection string .
i have the design like this in the control flow
Script Task -> DataFlow1 --> DataFlow2
we have to write a routine in the script editor which will decied which DataFlow it has to execute
Script Editor
--
Public Sub Main()
'Code to Invoke DataFlow1 or DataFlow2
End Sub
How to achive this in the script editor ?
Thanks
Jegan.T
|||I'm confused. At the start of this thread you said you were trying to execute a package.
NOW you say you are trying to decide which data-flow to execute.
The two are completely different so which is it? Perhaps you can explain exactly what it is you are trying to do.
If what you are trying to do is conditionally execute a data-flow then you are going about it the wrong way. You do not need to use a script task - use conditional precedence constraits which are described here: http://www.sqlis.com/default.aspx?306
-Jamie
No comments:
Post a Comment