Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

ICS SQL Server - Store Proc Table Type not Supported

edited Jan 22, 2020 7:17PM in Integration 5 comments

Summary

Trying to use SQL Server stored Procedure to insert data in batches- but encountering DBSPR001_GETPAGE Database type Table Type not supported or not implemented.

Content

Hi,

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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