Advanced Connection Properties

DTS Designer

DTS Designer Help

Advanced Connection Properties

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.

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.

See Also

DTS Connections