Advanced Connection Properties

DTS Import/Export Wizard Help

DTS Import/Export Wizard 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 varies depending on the properties supported by a particular provider. For more information, see the programming documentation for the individual OLE DB provider.

To change an OLE DB property value, in Value, click a cell, and then enter the new value.

Note  If you need to work more closely at the OLE DB level, the OLE DB Rowset Viewer, available with the OLE DB Software Development Kit (SDK), offers a simple way to view and manipulate OLE DB rowsets. It also gives you 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