Data Services 4.3 Bulk Load Options greyed out

dataservices job design
1

I have a job created in Data Services 4.3. The Bulk Load Options are greyed out on loaders to an MS SQL database server. I have done the following:

image
image766×326 41.2 KB

It did not change the situation. The following is the weird part and I know it is bass ackwards. The dev SQL server is a SQL 2019. The production database is a 2008r2. I do not know if this is causing the issue. I have a Data Services 3.2 installation. The bulk load to the SQL 2008r2 server is working. Any ideas on why the Bulk Load Options are greyed out?

2

I don’t use SQL Server, so the only question I can pose is, “What version of SQL Server is your Datastore using?”

3

It was in the message. Dev Microsoft SQL 2019 Prod Microsoft SQL 2008R2

4

Have you checked the PAM for Data Services 3.2 to see if both products are supported by it?

We’ve had a (non-SAP) product working fine on SQL Server 2016 and 2019 but not on 2022 for example.