• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

sql 2005: ssis flow control

hi all

i have an ssis app, that uses the  multicast transformation to allow 1 data set to be processed and posted to 2 different tables..

problem i have is, if i get an error in a data flow i want the other flow to also stop, currently it process's away and will post to a sql table regardless

is there some way of delaying this from happening?

cheers

mal
0
malraff
Asked:
malraff
  • 2
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
make both properties to true for package level as well
Untitled.png
0
 
ValentinoVBI ConsultantCommented:
I don't think that the further processing of your data flow can be stopped by settings.  The only option to get what you want, the way I see it, is to split your data flow up into several.

First prepare your data and store it in a (temporary) table or raw file.  Then set up additional data flows to put the data into your destination tables.  You can then use precedence constraints in the control flow to prevent further processing in case of error.
0
 
malraffAuthor Commented:
sorry for no feedback guys - im only back in the office now !
0
 
malraffAuthor Commented:
i think ur right Valentino!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now