Back to forum list… Back to How Do I?...

SQL Script Task errored in Scheduler (2 replies)

Arline Welty
6 years ago
Arline Welty 6 years ago

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"'

Support
6 years ago
Support 6 years ago

Remove the USE & Go commands.

DELETE
from MASTERMP
where KEYPURPOSE in ('ItemCost_Component', 'ItemCost_StockItem', 'ItemCost_KIt')

Arline Welty
6 years ago
Arline Welty 6 years ago

That worked, thank you.

Contact

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

Close

Request Demo

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

Close

Access Downloads

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

Close