Sequence of SSIS tasks - 11-02-2006 , 05:23 AM
I am developping an Integration Services package. It's really really
I have a task - in the Control Flow mask - in which I get a text file
and covert it (changing code page).
Another task in in the Data Flow and gets this file importing it into a
Sql Server table.
These two tasks are linked with a constraint: if the conversion fails
the package fails, otherwise the second step (import) starts.
When I ran these two simple steps in the designer everything is ok and
the order is respected:
When I try to run the package into a VB.NET applications it happens
that the Data Flow is always execute before the control flow ... so the
import is going to be executed before the conversion.
Can anybody help me???
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
Dim eventListener As New EventListener2()
pkgLocation = "C:\SSIS\Package2.dtsx"
pkg = app.LoadPackage(pkgLocation, eventListener)
pkgResults = pkg.Execute(Nothing, Nothing, eventListener,