Error while retriving data from Azure Data Source and destination in Azure SQL DB

Vathan G 116 Reputation points
2022-01-11T18:31:55.24+00:00

Hi All,
i am facing an issue while downloading data from Azure Source and inserting it into Azure SQL Using SSIS.

Below is the error message:
[Azure Blob Source [2]] Error: The Azure Blob Source was unable to process the data. One or more errors occurred.
[Azure Blob Source] Error: Pipeline component has returned HRESULT error code 0xC02090F5 from a method call.

Please help

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,821 Reputation points
    2022-01-12T08:39:08.28+00:00

    Hi @Vathan G ,

    I would suggest first check the data type of your data in source and destination. They should be same/compatible.

    Secondly, you may add data viewer after the source and see the data in the pipeline to see if it could load the data successfully.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Vathan G 116 Reputation points
    2022-01-12T14:27:56.78+00:00

    i verified all datatypes and they are looking good.
    i could see the data in the data viewer and it is fetching only 2 rows of data.
    this file has millions of records.

    0 comments