I dont have idea on partioining plese let me know example how to write it

I have one source table distributing data into two dest tables using incremental load concept but i need to insert new records if record already exists i wont insert...

Thankyou so much for replying me i resolved my issue........

http://www.codeproject.com/Articles/4451/SQL-Server-Transactions-and-Error-Handling

check out this link ....you can find the example of rollback stuff

Hi,

You can do the rollback in sql script or we can do in SSIS package

set the Transaction option property to required. and if you any sub tasks or...

Hi,

I tried to run sequentially it same and as i said when tried to load another table to access it got same errors as before

Got one more issue tried to load one table in different DB .. to Access DB

got same errors... sometimes it ran sucessfully access file is got crroupted...

thanks

Thankyou for replying..

I am processing parallelly two tables at a time

Table 1 has 2400167 and Table 2 has 259702

please let me the solution ..............That would be great...

In detail Errors

[OLE DB Destination [424]] Error:

SSIS Error Code DTS_E_OLEDBERROR.

An OLE DB error has occurred. Error code: 0x80004005.

[OLE DB Destination [424]] Error:

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR....

Yes I am missing some dll ..my issue is how to create MsAccess database and tables using SSIS

Its Assignment thanks for help....:-):-)