This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL Server Bulk Load

asepuri
New Contributor II

‎07-06-2017 11:26 AM

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,
3dc4cad571ddc63d1c16ed39b0fb201a391c7e2e.png

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

0 Kudos
Reply
5 REPLIES 5

ebarner
Former Employee

‎07-24-2017 08:12 AM

Arun,
I have confirmed with with our PM organization that customization (installing client utilities etc.) to CloudPlex enviroment is not possible. Previously I thought this was an option and I apologize for leading you down the wrong path.

You may want to try turning off AutoCommit to see if that improves performance at all.

0 Kudos
Reply