Contents hide 1 Introduction 2 Prerequisites 3 Step-By-Step Example-1 (Call AWS API) 4 Step-By-Step Example-2 (Loading data from AWS API to SQL Server) 5 File Upload Example – Low level API – Call PUT request 5.1 Upload Text File to S3 (i.e. JSON, CSV, XML …) 5.2 Upload Binary File to S3 (i.e. Zip, mp3, … Continue reading How to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)