Error executing SQL statement: insert into #x_task values... when importing job
Last Updated July 21, 2012
After exporting a Deployment Solution Job from the Console or via axExport.exe tool successfully you receive the message: Error executing SQL statement: insert into #x_task values, when trying to reimport the same job.
1) Go to Administrative Tools, open Data sources (ODBC)
2) Select System DSN and click "Configure" on the Altiris eXpress Database, click "Next" three times.
3) uncheck the "Use regional settings when outputting currency, numbers, dates and times." option, click finish and Test Data Sources.
4) Close and reopen the Deployment console, now you should be able to export and re-import the jobs successfully.
Deployment Solution 6.9 installed on a English version of Windows server 2003 operating system configured with any other Regional settings but English