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.
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.
Hello.
I am trying to use this to insert on the User_Role System Entity and I get the same error described on this question.
Can someone help?
The error is the following:
BulkInsert: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.Parameter name: DestinationTableNameat System.Data.SqlClient.SqlBulkCopy.set_DestinationTableName(String value) at OutSystems.NssBulkInsert.CssBulkInsert.SqlServerBulkInsert(IOSList recordList, String tableName, String columnsToIgnore, String referenceColumns, Boolean useTableLock, Dictionary`2 recordFields, String Catalog, String ExternalDatabaseConnectionName)
I used this a lot already in entities that are not system entities... Is it diferent?