SQL Script Task errored in Scheduler (2 replies)
Remove the USE & Go commands.
DELETE
from MASTERMP
where KEYPURPOSE in ('ItemCost_Component', 'ItemCost_StockItem', 'ItemCost_KIt')
That worked, thank you.
Remove the USE & Go commands.
DELETE
from MASTERMP
where KEYPURPOSE in ('ItemCost_Component', 'ItemCost_StockItem', 'ItemCost_KIt')
That worked, thank you.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
I don't understand why this is "wrong."
Here's the error in the IMAN API:
Description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'.
Line=26 Pos=0
Here's the SQL command called by SQL Script task:
USE DATABASEABC
GO
DELETE
from MASTERMP
where KEYPURPOSE in ('ItemCost_Component', 'ItemCost_StockItem', 'ItemCost_KIt')
Here's the description from Errors.txt:
Description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'.
Line=26 Pos=0
Time='09/27/19 02:10:25' App='IManEngine:3.2.100' ADO-version='6.3' Computer='xxx'
Method: VBWrapper.SimpleEvaluate
Number: -2147217900 = &H80040E14 = vbObjectError + 3604 = ERRMAP_APP_FIRST - 1594
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: Description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'.
Line=26 Pos=0
Call Stack: VBWrapper.SimpleEvaluate() -----------------------------------------------------------
COM Server Errors: Server={ScriptControl} Extractor={EEScriptControl}
Description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'.
Line=26 Pos=0
Call Stack: TransformTaskVbScript.RunScript() ----------------------------------------------------
Call Stack: TransformTaskProcess.INonDataTask_Initialise() ---------------------------------------
Call Stack: TransformCoordinator.RunTransform(sTransformId='DropMASTERMP_Items') -----------------
Env: eTransformType=103, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='DropMASTERMP_Items', l=0, m=0
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd={Text}
Value Of sCmd:
'"xxxx_MASTERMP_ICITEM Kit Drop and Load"'