Chapter 8 Quick Reference

Open table as spreadsheet

To	Do This
Create a new SSIS project	In Windows Explorer, navigate to the project, and then double-click the file to open it in BIDS. In BIDS, in Solution Explorer, double-click the file to open the package in design mode.
Execute a project	In BIDS, in Solution Explorer, right-click the project, and then click Execute Package.
Create an XML configuration file	In BIDS, on the SSIS menu, click Package Configurations. In the Package Configurations Organizer, select the Enable Package Configurations check box, and then click Add to start the Package Configuration Wizard. Follow the steps of the wizard to create the XML configuration file.
Edit an XML configuration file	Right-click the project file name, click Open With, select Microsoft Visual Studio Version Selector, and then click OK. In SSIS, on the Project tab, find <Configured Value> in the XML file. Between the <Configured Value> tags, locate the destination file and rename it.
Create an environment variable	Click Start, click My Computer, right-click the background, and then click Properties. In the System Properties dialog box, on the Advanced tab, click Environment Variables, and then click New.
Configure an environment variable	In BIDS, on the SSIS menu, click Package Configurations, and then click Add to start the Package Configuration Wizard. Follow the wizard steps to configure the environment variable.
Create a SQL Server configuration	In BIDS, on the SSIS menu, click Package Configurations, and then click Add to start the Package Configuration Wizard. In the Package Configuration Wizard, on the Select Configuration Type, select SQL Server and follow the wizard steps to create the SQL Server configuration.
Create a parent package variable configuration	In BIDS, on the SSIS menu, click Package Configurations, and then click Add to start the Package Configuration Wizard. In the Package Configuration Wizard, in the Select Configuration Type drop-down list, select Parent Package Variable, and then follow the wizard steps to create the Parent Package Variable configuration.
Execute a package using the DTExecUI utility	Open a Command Prompt window, type dtexecui, and then press Enter.
Execute a package using the DTExec utility	Open a Command Prompt window, type dtexec / followed by DTS, SQL, or file option and the package path.
Configure package logging	In BIDS, on the SSIS menu, click Logging.