August 27, 2008 at 12:17 am
Am doing dts to ssis conversion .... in dts i used to scall another task from inside the activex script .
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
SET PackObj = DTSGlobalVariables.Parent
SET ChildObj = PackObj.Steps("DTSStep_DTSActiveScriptTask_1")
ChildObj.Executionstatus =DTSStepExecStat_Waiting
Main = DTSTaskExecResult_Success
End Function
how do i do the same in SSIS
August 27, 2008 at 12:57 am
You can't.
Use precedence constraints to control the flow of the package.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 27, 2008 at 1:16 am
precedence control i cant use to fulfill my logic ... wat my dts does is say i have three files with same file name but the date part of file name varies (file name is say excel_finance_23042008.xls, excel_finance_23052008.xls etc) . DTS takes the first file and runs the package .... when i reach end of package i need to take the second file ..... and run the same package again .... problem is i cnt implement the logic using for each loop also .... i need to call in script only
August 27, 2008 at 1:21 am
Do you think SSIS can't or you can't?
If you use a loop, use substring in the constraint expression to extract the portion of the string you want.
You can now execute a specific task on conditions.
Precedence constraints are slightly more powerful than the red and green arrows. Double click one.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply