[BulkInsert] Getting error while using bulk insert  for outsystems table (Using physical name)
Question
Forge component by João Pedro Abreu

BulkInsert: System.InvalidOperationException: Cannot access destination table 'OSUSR_qy5_TEST'. ---> System.Data.SqlClient.SqlException: Invalid object name 'OSUSR_qy5_TEST'.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

Hi Rocky,


Probably you have the table in a diferent SCHEMA (Catalog). Try specify the catalog before the table name. 

Hi Rocky,

Open manage dependency and follow the steps given in below screenshot then click on apply.
then you can use this aggregate in your flow by using existing  table name in the filter then you will get entity ID and use this ID with getentity().entity.Physical_Table_Name in the table name input of the Bulkinsert action.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.