22 May 2014

About DTEXECUI.EXE


Packages execute in the same process as the dtexecui.exe utility. Because this utility is a 32-bit tool, packages run by using dtexecui.exe in a 64-bit environment run in Windows on Win32 (WOW).

When developing and testing commands by using the dtexecui.exe utility on a 64-bit computer, you should test the commands in 64-bit mode by using the 64-bit version of dtexec.exe before deploying or scheduling the commands on a production server.

The command line generated by dtexecui can be copied to a file and used with the CommandFile option in dtexec, or pasted directly to the Command Prompt window when running a package using dtexec.

Note: The Execute Package Utility (dtexecui.exe) is available only in a 32-bit version.
  • Open Management Studio.
  • On the View menu, click Object Explorer.
  • In Object Explorer, click Connect, and then click Integration Services.
  •  Expand the Stored Packages folder and its subfolders to locate the package to run, right-click the package, and then click Run Package.
  • In the Execute Package Utility dialog box, optionally, specify a different package to run.
  • Optionally, click Configurations, Command Files, Connection Managers, Execution Options, Reporting, Logging, Set Values, or Verification to update run-time options.
  • To review the command line that the utility uses, click Command Line.
  • Click Execute.
  • To stop the running package, click Stop in the Package Execution Progress dialog box.
  • When the package finishes, click Close to exit the Package Execution Progress dialog box.
  • Click Close. 


Note: If you cannot connect, verify that the Integration Services service is started. The status of the service can be set to either Automatic or Manual.

No comments:

Post a Comment