FIX: Error message when you use the DTExec.exe or DTExecUi.exe utility to run a SQL Server 2008 Integration Services package by specifying a configuration file: “The package path referenced an object that cannot be found” - Microsoft Support.

You try to run this package on systems where User Account Control (UAC) is enabled (for example, in Windows Vista or in Windows 7) by using one of the following methods: Business Intelligence Development Studio (BIDS) SQL Server Management Studio (SSMS) Object Explorer. DTExec.exe. DTExecUI.exe.

The DTExec.exe command prompt utility. If you want to list and to monitor SSIS packages in SQL Server Management Studio, you must start the SSIS service. The SSIS service provides the following management capabilities in SQL Server Management Studio: Retrieve an SSIS package from remote storage or from local storage.

Cause. The issue occurs because the configuration is ignored if CLR is implicitly activated in the Dtexec.exe process. The garbage collector mode is the default workstation mode. Resolution. The issue was first fixed in the following cumulative update of SQL Server. Cumulative Update 1 for SQL Server 2012 SP2 /en-us/help/2976982.

Workaround. To work around the issue, run the SSIS package by using the Execute Package Utility (dtexecui.exe) instead of the dtexec utility (dtexec.exe). More Information. For more information about the dtexec Utility (dtexec.exe), go to the following MSDN website:

Cause. This issue occurs because SSIS does not check whether the SSIS components are loaded successfully. If the SSIS components are not loaded successfully, SSIS validates and executes an empty Data Flow task. Note The dtexec utility returns an exit code whose value is 0. This value means that the SSIS packages were executed successfully.

This issue does not occur when you use Dtexec.exe to start SSIS packages that are stored in the file system or in the MSDB database. Symptoms. This issue occurs because of a problem in the [SSISDB]. [catalog]. [create_execution] stored procedure.

The DTExec.exe process runs parent packages. The DTSHost.exe process runs child packages. The DtsDebugHost.exe process runs packages that are debugged by Business Intelligence Design Studio. Cause. SSIS 2008 is notified that the server is under a low-memory condition.

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 - Microsoft Support. Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file.