Forum Discussion

asepuri's avatar
asepuri
New Contributor II
9 years ago

SQL Server Bulk Load

Hi All,

Am trying to load large volumes of data from Amazon S3 onto Sql Server Azure 2014. If I use ‘SQL Server Insert’ then it is taking way longer to load a single big table. Is there a way that bulk load option works without ‘BCP Absolute Path’ on cloudplex. Below is the pipeline,

For BCP absolute path, is it just generating a format file(xml or non xml) using bcp utility and uploading it onto snaplogic and referring the path in snap. Is my understanding correct or is there a better way to do this.

Thanks in advance!

-Arun