Share via

Flexible file Destination SSIS

David Brown 66 Reputation points
2021-10-06T15:32:38.423+00:00

Test connection succeeds to the Azure Data Lake Storage V2 account by using the access key, however when I run the ssis package I get an error about a missing file Microsoft.Azure.Storage.Common. How can I get around this error, as I am trying to export data from a VM SQL Server across to data lake storage account.

138218-2021-10-06-16-30-12.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,703 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator
    2023-07-23T18:23:11.9933333+00:00

    The error you encountered about a missing file "Microsoft.Azure.Storage.Common" indicates that the necessary Azure Storage SDK assembly is unavailable to the SSIS package at runtime. To resolve this issue, you must ensure that the required Azure Storage SDK assemblies are available on the machine where the SSIS package is being executed.

    You can install the SDK via the NuGet package manager, a standard way to add dependencies to your SSIS project. In Visual Studio, right-click on the SSIS project, choose "Manage NuGet Packages," and search for "Microsoft.Azure.Storage.Common." Install the package for the project.

    0 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.