Using Checkpoint Files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Using Checkpoint Files

Using Checkpoint Files

Rate Topic

Display Mode

Topic Options

Author

Message

dave-dj

Posted Wednesday, October 31, 2012 8:48 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 380, Visits: 1,014

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)

Post #1379364

subbareddy542

Posted Thursday, November 01, 2012 5:37 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:17 AM
Points: 832, Visits: 613

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)

Post #1379751

dave-dj

Posted Saturday, November 03, 2012 11:22 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 380, Visits: 1,014

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)

Post #1380730

« Prev Topic | Next Topic »

Permissions