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