Hi I have a SSIS package it will transfer 10 million of table from one table to another table inside the data flow. While executing the transaction log for the DB is full, the dataflow doesnot throw any error and it got completed and everything is green and when i happen to see in destination table is found the rows are missing. the data flow task completed very soon. Please let me know why the ssis doensot throw that the transaction log for the DB is full. Thanks in advance Karthikeyan.T

What destination component did you use in the dataflow?MCTS, MCITP - Please mark posts as answered where appropriate.

Soure and Destination is SQL server tables. Have you faced this type of issues?

Soure and Destination is SQL server tables. Have you faced this type of issues? No, I haven't faced this issue (yet). But I asked with the destination component was. SQL Server doesn't say anything. I can write rows to SQL Server with the OLE DB Destination, OLE DB Destination with Fast Load, OLE DB Component, ODBC connection, ADO.NET and I can go on...MCTS, MCITP - Please mark posts as answered where appropriate.