Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Unable to create the result table

Trying to use SF_TableLoader to upsert with an external id.

Here is the command I'm using -

EXEC SF_TableLoader 'UPSERT','SALESFORCE_SANDBOX_PARTIAL', 'Purchase_Order__c_Insert', 'Buyer_External_ID__c';

My input table has a column named -

Buyer__c.Buyer_External_ID__c

This is based on instructions in the DBAmp Install Guide for SF_TableLoader on pages 59 and 96.

A field named Buyer_External_ID__c was added to the User table.

Here is the error I'm getting. Any suggestions?

--- Starting SF_TableLoader for Purchase_Order__c_Insert V3.8.6
15:35:07: Run the DBAmpNet2.exe program.
15:35:07: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC
15:35:07: Parameters: upsert Purchase_Order__c_Insert salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL
15:35:07: Using the Salesforce SOAP API.
15:35:09: Drop Purchase_Order__c_Insert_Result if it exists.
15:35:09: Create Purchase_Order__c_Insert_Result with new structure.
15:35:09: Error: Unable to create the Purchase_Order__c_Insert_Result table.
15:35:09: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
The statement has been terminated.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
erEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
n inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at DBAmpNet2.LoaderSOAP.DropRecreateResultTable()
ClientConnectionId:1331104c-0b52-4c34-95fa-fb185efb3c99
Error Number:512,State:1,Class:16
15:35:09: DBAmpNet2 Operation FAILED.
Msg 208, Level 16, State 1, Line 25
Invalid object name 'Purchase_Order__c_Insert_Result'.
15:35:11: Error: DBAmpNet2.exe was unsuccessful.
15:35:11: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "UPSERT" "Purchase_Order__c_Insert" "" "salesforce_sandbox" "SALESFORCE_SANDBOX_PARTIAL" "Buyer_External_ID__c" " "
--- Ending SF_TableLoader. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_TableLoader, Line 334 [Batch Start Line 24]
SF_TableLoader Error: 15:35:07: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC15:35:07: Parameters: upsert Purchase_Order__c_Insert salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL 15:35:07: Using the Salesforce SOAP API.15:35:09: Drop Purchase_Order__c_Insert_Result if it exists.15:35:09: Create Purchase_Order__c_Insert_Result with new structure.15:35:09: Error: Unable to create the Purchase_Order__c_Insert_Result table.15:35:09: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.The statement has been terminated. 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncW...
1 person has
this question
+1
Reply
  • Can you post a create table statement for the Purchase_Order__c_Insert table? Does this error occur every time you try the command?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Yes, I get the error everytime.

    USE [salesforce_sandbox]
    GO

    /****** Object: Table [dbo].[Purchase_Order__c_Insert] Script Date: 8/13/2019 4:26:20 PM ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE [dbo].[Purchase_Order__c_Insert]
    (
    [Buyer__c.Buyer_External_ID__c] [nchar](18) NULL,
    [DatePOCompleted__c] [datetime2](7) NULL,
    [Id] [nchar](18) NULL,
    [MemoCode__c] [nvarchar](1) NULL,
    [Name] [nvarchar](80) NULL,
    [OrderEntryDate__c] [datetime2](7) NULL,
    [OrderStatus__c] [nvarchar](1) NULL,
    [PurchaseOrder__c] [nvarchar](6) NULL,
    [ShippingInstrs__c] [nvarchar](30) NULL,
    [Supplier__c] [nchar](18) NULL,
    [TermsCode__c] [nvarchar](2) NULL
    ) ON [PRIMARY]
    GO
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Also, sorry if this got posted several times. It didn't seem like it was working.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • The upsert operation wants an external id on the object being updated or inserted.

    You passed an external id of Buyer_External_ID__c but there is not an external id field on the Purchase_Order__c object that is external and unique.

    I think you are confusing the 2 ways external ids are used:

    1. To drive an Upsert: here the external id must exist on the object being upserted
    2. To drive foreign_key: here we are looking up a foreign key by ITS external id.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Does the Purchase_Order__c object have a field that is declared on salesforce as a unique external id ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Here is a screenshot of the Purchase_Order__c object. I'm try to upload a list of POs, each may have a different buyer code from our system. Buyer__c and Supplier__c were setup as Lookups so I don't know how to get the data uploaded.

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • A field named Buyer_External_ID__c was added to the User object.

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Each PO may have one supplier. For Supplier__c I was hoping to use the value put in the Account Name.

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • The example in the install guide is not clear to me. It says -

    "To do this, modify the column name of the input table and add a period
    followed by the external ID field name."

    And gives AccountId.SAPXID__c as an example of a column name in an input table.

    What is the "AccountId" portion of the column name?

    It looks like SAPXID__c is a field added to the Accounts object.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • The only external id on the Purchase_Order__c object is PurchaseOrder__c.

    Therefore you can only upsert into this object where you are using that column as the driver of the upsert:

    EXEC SF_TableLoader 'UPSERT','SALESFORCE_SANDBOX_PARTIAL', 'Purchase_Order__c_Insert', 'PurchaseOrder__c';

    All the Buyer stuff you are talking about is using the external id of a user record to resolve a foreign key and there is (presumably) no problem with that.

    So try the command above instead of your command and report the result.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • I ran the following command -

    EXEC SF_TableLoader 'UPSERT','SALESFORCE_SANDBOX_PARTIAL', 'Purchase_Order__c_Insert', 'PurchaseOrder__c';

    Here is the result -

    --- Starting SF_TableLoader for Purchase_Order__c_Insert V3.8.6
    09:47:20: Run the DBAmpNet2.exe program.
    09:47:20: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC
    09:47:20: Parameters: upsert Purchase_Order__c_Insert IW-SQL01\SQLEXPRESS salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL
    09:47:20: Using the Salesforce SOAP API.
    09:47:22: Drop Purchase_Order__c_Insert_Result if it exists.
    09:47:22: Create Purchase_Order__c_Insert_Result with new structure.
    09:47:22: Error: Unable to create the Purchase_Order__c_Insert_Result table.
    09:47:22: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
    The statement has been terminated.
    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.SqlDataReader.TryConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
    erEncryptionRequest)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
    n inRetry)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader()
    at DBAmpNet2.LoaderSOAP.DropRecreateResultTable()
    ClientConnectionId:d52bc45b-724b-4ecd-a10e-04d4bab67093
    Error Number:512,State:1,Class:16
    09:47:22: DBAmpNet2 Operation FAILED.
    Msg 208, Level 16, State 1, Line 5
    Invalid object name 'Purchase_Order__c_Insert_Result'.
    09:47:24: Error: DBAmpNet2.exe was unsuccessful.
    09:47:24: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "UPSERT" "Purchase_Order__c_Insert" "IW-SQL01\SQLEXPRESS" "salesforce_sandbox" "SALESFORCE_SANDBOX_PARTIAL" "PurchaseOrder__c" " "
    --- Ending SF_TableLoader. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_TableLoader, Line 334 [Batch Start Line 4]
    SF_TableLoader Error: 09:47:20: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC09:47:20: Parameters: upsert Purchase_Order__c_Insert IW-SQL01\SQLEXPRESS salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL 09:47:20: Using the Salesforce SOAP API.09:47:22: Drop Purchase_Order__c_Insert_Result if it exists.09:47:22: Create Purchase_Order__c_Insert_Result with new structure.09:47:22: Error: Unable to create the Purchase_Order__c_Insert_Result table.09:47:22: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.The statement has been terminated. 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncW...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Do you get the same error when you run the following:

    EXEC SF_TableLoader 'Upset:bulkapi','SALESFORCE_SANDBOX_PARTIAL', 'Purchase_Order__c_Insert', 'PurchaseOrder__c';
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • I ran this -

    EXEC SF_TableLoader 'Upsert:bulkapi','SALESFORCE_SANDBOX_PARTIAL', 'Purchase_Order__c_Insert', 'PurchaseOrder__c';

    and got this -

    --- Starting SF_TableLoader for Purchase_Order__c_Insert V3.8.6
    10:06:19: Run the DBAmpNet2.exe program.
    10:06:19: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC
    10:06:19: Parameters: upsert Purchase_Order__c_Insert salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL
    10:06:19: Using the Salesforce BulkAPI.
    10:06:21: Sort column will be used to order input rows.
    10:06:21: Warning: Column Sort ignored because it does not exist in the purchase_order__c object.
    10:06:21: Drop Purchase_Order__c_Insert_Result if it exists.
    10:06:21: Create Purchase_Order__c_Insert_Result with new structure.
    10:06:21: Error: Unable to create the Purchase_Order__c_Insert_Result table.
    10:06:21: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
    The statement has been terminated.
    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.SqlDataReader.TryConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
    erEncryptionRequest)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
    n inRetry)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader()
    at DBAmpNet2.LoaderBulkAPI.DropRecreateResultTable()
    ClientConnectionId:161c4d31-affe-454d-805e-ff0edebdf30f
    Error Number:512,State:1,Class:16
    10:06:21: Deleted file: C:\DBAmpWorkArea\Purchase_Order__c_Insert.csv
    10:06:21: DBAmpNet2 Operation FAILED.
    Msg 208, Level 16, State 1, Line 7
    Invalid object name 'Purchase_Order__c_Insert_Result'.
    10:06:23: Error: DBAmpNet2.exe was unsuccessful.
    10:06:23: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsOldBulk "Upsert:bulkapi" "Purchase_Order__c_Insert" "" "salesforce_sandbox" "SALESFORCE_SANDBOX_PARTIAL" "PurchaseOrder__c" " "
    --- Ending SF_TableLoader. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_TableLoader, Line 334 [Batch Start Line 6]
    SF_TableLoader Error: 10:06:19: DBAmpNet2 3.8.6.0 (c) Copyright 2015-2017 forceAmp.com LLC10:06:19: Parameters: upsert Purchase_Order__c_Insert salesforce_sandbox SALESFORCE_SANDBOX_PARTIAL10:06:19: Using the Salesforce BulkAPI.10:06:21: Sort column will be used to order input rows.10:06:21: Warning: Column Sort ignored because it does not exist in the purchase_order__c object.10:06:21: Drop Purchase_Order__c_Insert_Result if it exists.10:06:21: Create Purchase_Order__c_Insert_Result with new structure.10:06:21: Error: Unable to create the Purchase_Order__c_Insert_Result table.10:06:21: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.The statement has been terminated. 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehav...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Can you run the following query in the same database you are running the SF_TableLoader in and report back the results:

    select * FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'Purchase_Order__c_Insert'
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Try running the following in the same database:

    Select Top 0 * into [Purchase_Order__c_Insert_Result] from [Purchase_Order__c_Insert]
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • I ran this -

    Select Top 0 * into [Purchase_Order__c_Insert_Result] from [Purchase_Order__c_Insert]

    And got this -

    (0 rows affected)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Can you send an email to support at forceamp.com (support@forceamp.com) so we can setup a goto meeting and take a look?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited