Load data issue in ssis

Landon S 40 Reputation points
2023-10-30T02:03:30.61+00:00

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.
13,998 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,591 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 21,725 Reputation points
    2023-10-30T02:34:06.06+00:00

    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 25,956 Reputation points
    2023-10-30T02:46:02.29+00:00

    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 37,671 Reputation points
    2023-10-30T03:26:41.04+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.