Integration Services (SSIS)
SQL Server Integration Services loads for WhereScape RED
A common warning seen in the Scheduler audit log when using Integration Services loads is:
Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the s...
Scenario When running an Integration Services load in a SQL Server repository either interactively or via the Scheduler, an error with message "WhereScape SSIS Integrator stopped working" sometimes. Additionally, the below error message may also pop up in this case: Cause ...
Scenario Integration Services loads on a newly configured computer (PC or server) do not work. You may see an error similar to "Execution of Image WslSDL.exe failed". Cause RED Integration Services loads require components that are installed with SQL Server client tools, specifically...
Scenario
RED can automatically generate Integration Services packages for Load tables, however in some situations it is a requirement to run an arbitrary Integration Services package that contains some specialised functionality or has been migrated from a legacy environment.
Sol...