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

Unclosed quotation mark after the character string

Hi,

I'm trying to run this bulk ops statement

Exec SF_BulkOps 'insert:bulkapi','SALESFORCE','[UAT_NBN].[dbo].[Case_Staging]'

I'm getting this error

--- Starting SF_BulkOps for [UAT_NBN].[dbo].[Case_Staging] V3.2.3
15:39:42: Run the DBAmp.exe program.
15:39:42: DBAmp Bulk Operations. V3.2.3 (c) Copyright 2006-2016 forceAmp.com LLC
15:39:42: Inserting [UAT_NBN].[dbo].[Case_Staging] (094-T430U-THINK\SQLEXPRESS / salesforce backups).
15:39:42: DBAmp is using the SQL Native Client.
15:39:44: Error: Failed to execute command to create result table.
Source: Microsoft SQL Server Native Client 11.0
Description: Unclosed quotation mark after the character string 'Case_Staging] where 1=0 '.
Source: Microsoft SQL Server Native Client 11.0
Description: Incorrect syntax near '_Result'.
15:39:44: Error: DBAmp.exe was unsuccessful.
15:39:44: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe insert:bulkapi [UAT_NBN].[dbo].[Case_Staging] "094-T430U-THINK\SQLEXPRESS" "salesforce backups" "SALESFORCE" " "
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 141
SF_BulkOps Error: 15:39:42: DBAmp Bulk Operations. V3.2.3 (c) Copyright 2006-2016 forceAmp.com LLC15:39:42: Inserting [UAT_NBN].[dbo].[Case_Staging] (094-T430U-THINK\SQLEXPRESS / salesforce backups).15:39:42: DBAmp is using the SQL Native Client.15:39:44: Error: Failed to execute command to create result table.Source: Microsoft SQL Server Native Client 11.0Description: Unclosed quotation mark after the character string 'Case_Staging] where 1=0 '.Source: Microsoft SQL Server Native Client 11.0Description: Incorrect syntax near '_Result'.

Any assistance would be appreciated.
1 person has
this problem
+1
Reply