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 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.