SAP Knowledge Base Article - Preview

2721249 - Can Data Services 4.2 SP7 load data to a Microsoft SQL Server 2016 database?

Symptom

  • When loading data from Data Services 4.2 SP7 into a Microsoft SQL Server 2016 gets an error, as listed below:
    |SESSION <Job_name> |WORKFLOW <Workflow_name> |DATAFLOW <Dataflow_name>
    None of the configurations for the specified target table <Target_table_name> contain a database match Microsoft SQL Server 2008 for the current datastore <Datastore_name>.
    For optimal results, always migrate data flows with associated datastore information.
    NOTE: If you migrated data flows without associated datastore information, import the necessary datastore from the source and add a new datastore configuration to match the new environment.
    When adding a new datastore configuration, set the "Use values from" option under "Values for table targets and SQL transforms" in the "Create New Configuration" window to use the configuration from which you migrated. You can make the new datastore configuration your default or use system configuration to instruct Data Services to use the new datastore configuration. For more migration information, see the Advanced Development and Migration Guide.

Read more...

Environment

SAP Data Services 4.2 SP7.

Product

SAP Data Services 4.2

Keywords

Datastore, Datastore Configuration, New Datastore Configuration, Advanced Development and Migration Guide, Microsoft SQL Server 2016 , KBA , EIM-DS-SVR , Data Services Administration/Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.