October 31, 2012 at 8:48 am
Afternoon all.
Has anyone used checkpoint files where a data flow splits data and updates two destinations? On question relating to this and the use of checkpoint files is, if one insert in the data flow fails - does the whole data flow task get rolled back like a transactions?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
November 1, 2012 at 5:37 am
for excel one data flow under that 2 oledb sourse is there.
one for to load data from 12 server to 60 server
second one load dada from 13 server to 60 server
but first one fial second one is sucess
next time you will run that package that time only excute
fir one( load data from 12 server to 60 server)
November 3, 2012 at 11:22 am
ok - so thats all under one data flow.
my data flow is slightly different. I have 1 OLE DB Source, but use mutli cast and splits the data to another table insert a table updated and a table delete (not all the same table!)
may easier to picture like so
OLE src >> multi cast >> data path one >>>>>>>>>>>>>>>>> table insert
data path two >> conditional split >> table update
>> table table delete.
What I want to understand is will the data flow act as transaction where either everything commits or everything is rolled back?
As time is against me I've split these to seperate bits of work, but I'm still interested to know for future work.
thanks all
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply