Download file in AWS S3 bucket using SSIS

Sinah Molepo 20 Reputation points
2024-01-21T21:05:43.86+00:00

Is there a way to download a file from AWS S3 source to local using SSIS? I have files in different formats like json, csv that are sitting in ASW S3 and I would like to load the data in SQL Server On Prem using SSIS. The files comes in different names daily, the method should also enable me to pass variables of the file name and file path that needs to be downloaded. Can I achieve this without using any third party tools that need payment?

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,214 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,503 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,836 Reputation points
    2024-01-22T03:43:15.58+00:00

    Hi @Sinah Molepo,

    You can browse Visual studio Marketplace and use Amazon S3 SSIS Components (SSIS Productivity Pack) which is a free tool. It enables SSIS package and Amazon S3 SSIS bucket integration without writing any specific code. You can easily use this SSIS productivity pack to download complete the task effectively and efficiently.

    See here for details.

    Regards，

    Zoe Hui

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

    0 comments