Hi
I feel as if I'm going round in circles and do not seem to be getting very far and really open to how to do this.
Client uses an Amazon S3 bucket which they load flats files to . They also expect files to be delivered there to.
So at the minute I have an SSIS package (SQL2012 ) which I use to generate some files but then have to manually import the files to the S3 bucket as well as export others.
Now Mike Yin ( For SQL2008R2 ) mentioned that you need to obtain 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.
Im not getting far with this
Steps so Far
- Installed both 32 and 64bit 9.03.
- New connection Manager
- ADO.NET - New then drop the provider down to ODBC.Dataprovider
Then what ? Do I put the S3 bucket address within the use connection string ? Is there and example ? Why do I need the PostgreSQL ODBC as Im not connecting to a database just a S3 Bucket?
Any help on this would great be great
Many Thanks
Robert