Looking at the code snippet, you also have to pass Server and Database names as inputs. Have you?
Also, change the input parameter name, InputData to DataCollection.
@naveedraza can you share more details of your code usage?
While applying filter, you have to use the field names and not Collection name dot field name.
If Name and Age are the fields of collection, you can use "Name ="&[DataItem1]&"AND Age="&[DataItem2]&". If you have the values to compare Name and Age in data items DataItem1 and DataItem2...
@naveedraza Reading the problem statement, @Pallavivalunj is looking to insert data directly in to SQL Server from Excel as there is memory issue while copying such huge data of 80k to 1lakh records from Excel into Collection.
I am assuming, your solution holds well when trying to write...
The Field Names of the 'Named Values' collection should be 'Name' and 'Value'. You have named fields as 'ProdCode' and 'Value'.
Add a row to the 'Named Value' collection and put 'ProdCode' in to 'Name' column and leave 'Value' field blank. On successful execution 'Value' will be updated in the...
Check if you have blank values in excel file. One of the reasons for the exception is when there is an attempt to convert text which is blank to number.
"Unable to convert supplied value to a Number : Unable to cast value ' ' to a number data item"
Using T-SQL OPENROWSET, you can perform the data move from excel to SQL server. Check this link for more details-