April 2, 2014 at 6:41 am
Hi All,
AM trying to export a dataset of 1 million records from Hadoop to sql server using sqoop which internally uses microsoft.sqlserver.jdbc for data transfer. It is aborting the data transfer with the below error message. But, If i transfer it by batches of 10 records it is working fine but too slow. Is there any way to solve this issue and make bulk load with good performence. Am in need of your valuable suggestion and clue to solve this issue.
Error:
"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."
April 9, 2014 at 4:33 pm
Do you have the option to dump the data to text and then use SSIS to import from the text file to SQL? Another alternative, is there an oledb or odbc driver your other system so SSIS could pull the data and load it?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply