Query csv file S3 bucket from SSMS

rajanisqldev-42 206 Reputation points


I have csv files on Amazon S3 bucket.

How can I load files from S3 bucket to Sql Server DB or query from SSMS?


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,415 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Bruce (SqlWork.com) 52,826 Reputation points

    no support in SSMS. you can use SSIS.


    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 30,881 Reputation points

    Hi @rajanisqldev-42

    You may try with SSIS to load data from Amazon S3 bucket to SQL Server database.

    Check this for details.


    Zoe Hui

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

    0 comments No comments