Advanced Connection Properties
New Information - SQL Server 2000 SP3.
Use this dialog box to set custom values for certain OLE DB initialization properties. The OLE DB advanced properties available for customization will vary depending on the properties supported by a particular provider.
To change an OLE DB property value, in Value, click a cell, and then type the new value.
Security Note When a package runs attended then the Persist Security Info property can be set to False. The default value for this property is True.
Note If you need to work more closely at the OLE DB level, use the OLE DB Rowset Viewer, available with the OLE DB Software Development Kit (SDK). The OLE DB Rowset Viewer offers a simple way to view and manipulate OLE DB rowsets with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider.