Load data issue in ssis

Landon S 40 Reputation points

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,587 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,322 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 8,390 Reputation points

    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.

    0 comments No comments

  2. Yitzhak Khabinsky 24,011 Reputation points

    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/]

    0 comments No comments

  3. ZoeHui-MSFT 27,391 Reputation points

    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.


    Zoe Hui

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

    0 comments No comments