ICS SQL Server - Store Proc Table Type not Supported
SummaryTrying to use SQL Server stored Procedure to insert data in batches- but encountering DBSPR001_GETPAGE Database type Table Type not supported or not implemented.
Any inputs/comments on this please. Thanks in advance !
I have a requirement to load a SQL Server database Table(On Prem database ) from a CSV File. For each loop was too slow, so I created a stored procedure to handle the batch insert .
I did the following and it works fine when I test in Sql Sever query window ( rows get inserted).
Step1 : CREATE TYPE PROJTableType AS TABLE
( [PROJECT_NUMBER] [varchar](20) NOT NULL,