Hi, We have a few customers dropping files in Amazon S3. Could you please let me know how to load this data into SQL Server 2008 R2 database using SSIS? We are 2008 R2 BIDS environment.
Thanks in advance........
Technology Tips and News
Hi, We have a few customers dropping files in Amazon S3. Could you please let me know how to load this data into SQL Server 2008 R2 database using SSIS? We are 2008 R2 BIDS environment.
Thanks in advance........
There's a thid party connector available for this
http://www.cozyroc.com/ssis/amazon-s3-connection
also see
http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_27733447.html
Hi ione721,
You can install the PostgreSQL ODBC driver so that you can use the .Net Providers\Odbc Data Provider for ADO.NET Source component to connect to the Amazon cloud storage. After that, you can use a OLE DB Destination to load the data to SQL Server database.
Reference:
http://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html
Regards,
Hi,
You have few options... command line tools to download S3 files on local machine and then import to sql server using BCP.
Some popular command line tools
Or Use SSIS with some 3rd party Tasks like below... and the use DataFlow to read FlatFile into SQL Server.
Amazon S3 Cloud Storage Task |
|