October 31, 2018 at 9:27 am
So, I have to export tables from SQL server and save them as csv files on my local machine and then export them in blob storage. (Azure Cloudberry, in my case). Can someone guide me on this?
Solution: So to export the SQL tables in csv format I created SSIS packages which exports these tables on my machine in csv. However, I am struggling with exporting this csv into our blob location/containers.
Any help will be much appreciated.
October 31, 2018 at 10:41 am
v-afbhur - Wednesday, October 31, 2018 9:27 AMSo, I have to export tables from SQL server and save them as csv files on my local machine and then export them in blob storage. (Azure Cloudberry, in my case). Can someone guide me on this?Solution: So to export the SQL tables in csv format I created SSIS packages which exports these tables on my machine in csv. However, I am struggling with exporting this csv into our blob location/containers.
Any help will be much appreciated.
Why use Cloudberry? Why not use AzCopy - a free Microsoft command-line tool designed for this sort of job? I've used it in the past for migrating files on a schedule, and it'll go to blobs as well.
Thomas Rushton
blog: https://thelonedba.wordpress.com
October 31, 2018 at 11:53 am
haa interesting, I can take a look at it. Thanks for your suggestion!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply