i have a ssis package. In this package, xml file data dumps to the sqlserver table.
after this, the package calls procedure which is used multiple update statements.but it causing Transaction log full because of the xml file contains 30 lakhs records(i mean in a table after dumping).
but one of my colleague advised to use checkpoint...iam not able to use this....because it is not marking at particular record..means it can not remembering after some records are updated.
can you help me on checkpoint,how remember the particular records..
can you help me on other suggesstions?
View Complete Post