Preactor Support

We can see the problem on your screen if you download the sl-ect Teamviewer utility:

Tel: 0844 3580777

Email:

Interface Settings:

SSISLocation Values of:

SSIS - where SSIS is installed on the local user PC and dtexec is to run directly
SageSQL - run using SQL commands on the Sage SQL server
PreactorSQL - run using SQL commands on the Preactor SQL server

SSISMode Values of:

SProc - where SSIS is called using a SQL Stored Procedure (requires xp_cmdshell to be enabled)
SJob - where SSIS is called using a SQL Agent Job (DOES NOT require xp_cmdshell to be enabled)

SSISVersion Values of:

Command Line Parameters: (set in the .prcdf file)

AutoRun-n - suffix with -y to start the import/export automatically when the application launches
AutoClose-n - suffix with -y to close the import/export at the end (will not apply if errors are found)
DtsxOutput-y - suffix with -n to show less information in the interface results window (overriden by the debug mode)
CsvTimeCheck-10 - suffix with -07 to error if the timestamp on the OrdersIn file is greater than 7 seconds old (used to warn the user if the Import to Preactor has not run properly)

Error Messages: In the "Results" box when background = Red

End of file reached before Preactor connection string found : Check .prcdf file
Failed to open slectPREACTORConnection : Check the connection string for the Preactor database
Failed to open slectSSISConnection : Check the connection string for the SSIS server
Select Preactor slectConfig setting XXXXX not found : In the SlectConfig table a mandatory setting XXXXX is missing
Run DTSX via XXXXX : Error executing SSIS package - check on screen for more detailed information about the error. For example: "Error Number :80040E10"
OrdersIn file not created, or an old time stamp indicates that there was a problem : Check the Import folder