In the Host parameter you need to specify all members of the MongoDB replica set using the following syntax host1[:port],host2[:port] . Then in the Advanced tab, you need to set to add a replicaSet parameter (e.g. replicaSet=my-replica-set)
Action: When running my package manually by VS it executes succesfully, but when I run it by SQL Agent job I get the following error message: Unable to connect to a member of the replica set matching Secondary Preferred Error Message: An error ...
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the MongoDB Connection can be found at the following link. For many of the components you can find ...
In some MongoDB instances, even if the "Test Connection" indicates that "Test connection succeeded", some operations in the MongoDB Source or MongoDB Destination might fail, due to the default value CSharplegacy for GuidRepresentation. To remedy this ...
A composite record models an array item in a MongoDB document. The nested document in such an array usually have the same set of fields, thus they are modeled by a separate input (named after the array element path). For each parent record (e.g. a ...