As my project requires to have 10 datatables with 6-8 columns each and 1,00,000+ rows, I am willing to write these datatables in batches of 1000 rows into the SQL server.
Below are the pointer which I know and followed so far:-
Earlier, I used to write these batches in the excel using (“write range” and “append range”)
Now, I have established the SQL connection successfully and about to use Insert activity.
I have also created corresponding Table names and Column names in the database, so all I need to do is to use the Insert activity using batches.
My question is, as I used Write Range and Append Range in the excel application scope, I want to have a same effect in the SQL database. So can I expect that the data is appended correctly using the “Insert Activity” following the proper headers and table names?
Just curious to understand before I modify my code. Hope my question is well understood.
Thanks and Regards,