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!