Load data issue in ssis

Question

I have a simple table Which contains 100+rows.

When i load the data to another sql table, it only load 30rows without any error message.

Answer 1

Hi @Landon S,

Please first make sure that the data type is matched between the two tables.

You can create a second OLE DB Destination and direct the red arrow from your Data Conversion task to this destination. Then choose Configure Error Output in your Data Conversion task and choose Redirect row as an option for all Errors/Truncations. So that you could see if the rest rows is in the error output.

In addition, you may re-create a package and then re-add the component for a try.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Landon S,

Please edit your question and add a screen shot of your Data Flow Task (DFT). Before that please add SSIS Data Viewer to the DFT. It will allow you to troubleshoot and explicitly see number of rows going through the SSIS pipeline.

Check it out here: [http://binaryworld.net/blogs/use-ssis-data-viewer-dataflow-task/]

Answer 3

Check the data types of columns in the source table and the destination table. If the destination table has narrower columns than the source table, it can result in data truncation.

Ensure the destination table's column types are compatible with the source data.