To view and/or edit the properties of an SSIS Configuration file. Many of these properties will be used as default values on the Generate Package page.
|
|
Click the Save icon in the toolbar to close the window and save the entered information to the configuration file. |
|
|
Click the Cancel icon in the toolbar to close the window without saving any changes. |
|
|
Click the Help balloon to open the help for this page. |
N/A
You must have one or more SSIS configuration files available for editing and the proper file system security must be setup to allow saving this file.
This page is intended for advanced users. Take care while entering or editing the information on this page because it is not validated. You must know what to enter for each of the fields below.
Be sure to enter all path names using UNC format, and make sure those paths are accessible from the server where MS SQL Server is running. See the glossary entry for UNC for more information.
Note, this page shows all values that exist in the configuration file being edited and displays them in the order they exist in that file. Therefore, the order of the fields shown below may not match your configuration file. The fields listed below are the primary fields used for SSIS configuration, If any other fields are displayed you should change them at your own risk.
| Configuration File | Display only field for the configuration file you are currently viewing. |
| SQL Server | The name of the server where the SQL Server database is located. |
| SQL Database | The name of the SQL Server database you will be updating with the SSIS packages. |
| Use Windows Authentication | If you want to use the currently logged in user's username and password for the SSIS package to log into the SQL database, select the Windows Authentication checkbox. There user could be an actual user or a system user (as in the case of a service that is running the package). If you do not select Windows Authentication, SQL Server Authentication will be used and you must enter the username and password to login to the database. |
| Username | The username to be used when the SSIS package logs into the SQL database. This is only used if Windows Authentication is not selected. |
| Password | The password to be used when the SSIS package logs into the SQL database. This is only used if Windows Authentication is not selected. |
| SMTP Connection Manager SmtpServer | The name of the mail server to use when delivering mail. This is required in order to deliver any error messages generated when processing SSIS packages. |
| Package Variable SMTPFrom | This is the valid e-mail address that you would like to use as the FROM address when sending e-mails generated by the SSIS package. |
| Package Variable SMTPTo | This is the valid e-mail address where you would like all e-mails generated by the SSIS package to be sent TO. |
| Package Variable SMTPCc | This is the valid e-mail address where you would like all e-mails generated by the SSIS package to be carbon copied (CC'd) to. |
| Package Variable SMTPBcc | This is the valid e-mail address where you would like all e-mails generated by the SSIS package to be blind copied (BCC'd) to. |
| Package Variable SMTPDataSubject | This is the subject line to be used by all e-mails generated by the SSIS package when DATA errors are encountered. |
| Package Variable SMTPDataMessage | This is the text to be used as the message body by all e-mails generated by the SSIS package when DATA errors are encountered. |
| Package Variable SMTPFileSubject | This is the subject line to be used by all e-mails generated by the SSIS package when FILE errors are encountered. These e-mails will only be sent if the "Error if import file(s) are not present" option is checked on the Generate Package for SQL Export page. |
| Package Variable SMTPFileMessage | This is the text to be used as the message body by all e-mails generated by the SSIS package when FILE errors are encountered. |
| Package Variable MaxEmailFileSize |
This valued indicated the maximum size of a file (in bytes) that can
be attached to an e-mail and successfully delivered. Default value
is 5242880 because many e-mail systems have a 5 MB attachment
limit. Enter the value that conforms to your system limit.
After a SSIS package completes processing, an e-mail is sent to the address specified in the SMTPTo package variable. That e-mail will include an attachment will all the errors if the size of the attachment is less than the value entered here. If the attachment is larger than this value, then the e-mail will be sent with a link the the attachment instead. |
| Package Variable DataDirectory | The valid directory path to a location used to indicate where all data files extracted using the SQL Data Export Specification will be saved. The SSIS packages will look in this location for files that are ready to process and import into SQL Server database. |
| Package Variable LogDirectory | The valid directory path to a location where the SSIS packages will save all log and errors files generated while processing packages. |
| Package Variable MaxToleratedErrors | This value specifies the maximum number of errors allowed while processing a SSIS package for a file. Once this limit is reached the SSIS package process will stop. |
| Package Variable Debug | NOT USED |