You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DB Table loading using Batch Insert using ICS from CSV

edited Jan 31, 2018 8:00AM in Integration 11 comments

Summary

DB Table loading using Batch Insert using ICS from CSV

Content

Hi,

I have a requirement of loading a DB Table from a set of CSV Files data.Apart from the regular stored procedure option I need to know if ICS has the capability to handle a batch insert .

I have successfully inserted the data using a DB insert inside a for-Each on the RecordSet, but as this does not seem to be the most efficient way of doing batch insert,please suggest If ICS has any functionality to handle multiple database insert from a repeating RecordSet.Any suggestion will be helpful.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!