Publish date: 2014-06-13

IBProvider 3.20. Improved a support of MS DTS and SSIS

Support of utility MSSQL «Import&Export» and SSIS.

  • Now the IBProvider’s installer automatically offers to install the files for data type conversion into directory of MSSQL (2005/2008/2012).
Screenshot. IBProvider installer. Allowing on installation of integration files.
Installation of integration files.
Screenshot. IBProvider installer. Selection of MSSQL versions, for which should install the integration files.
Installation of integration files into MSSQL directory.

Changes in the «Data Link» dialogue for configuration of connection properties.

Screenshot. Setup of initialization property "named_param_rules" through the user interface of "Data Links" dialog.
Configuration of property «named_param_rules».

Changes in metadata schemas.

  • New column PROCEDURE_COLUMNS::COLUMN_FLAGS.
  • New column PROCEDURE_PARAMETERS::IS_LONG.
  • New column PROCEDURE_PARAMETERS::IS_FIXEDLENGTH.

These additional columns can be used for determination of correct data type identifier of column/parameter of stored procedure/function.

Outer changes.

Bugs fixed.

  • Errors in the PROVIDER_TYPES schema.
  • Errors in the «Data Link» dialogue.

Publish date: 2014-06-13. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.