LDAP Destination attribute sAMAccountName for object Group is not initialized in the metadata
If LDAP Destination column sAMAccountName is missing in the metadata for object Group then you should follow the steps below:
1. Open the LDAP Destination dialog box and go to the 'Input and Output Properties' tab.2. Go to LDAP Destination -> External Columns list and add a column 'samaccountname'. Specify the type to be DT_WSTR and length 250.3. Go to LDAP Destination-> Output Columns list and add a column 'samaccountname'. Specify the type to be DT_WSTR and length 250.4. Go to 'Column Mappings' tab and map the external -> output samaccountname column.
If the sAMAccountName is still not being seen, then you need to check if the user that you have used in the connection is allowed to retrieve the sAMAccountName.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
When I'm querying the object Security Principal while using LDAP Source, how can I return the sAMAccountName?
If you are not seeing sAMAccountName in the metadata then you should: 1. Open the LDAP Source dialog and go to the 'Input and Output Properties' tab. 2. Go to LDAP Source -> External Columns list and add a column 'samaccountname'. Specify the type ...LDAP Destination: How to modify a LDAP destination object dynamically at runtime
The destination object is available in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select the Properties menu. Scroll down and find the property named like [LDAP ...LDAP Source: How to modify the source object dynamically at runtime
The source object parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired object name. Right-click on the data flow canvas and select ...How to know if a column is missing in my excel file when using Excel Source Plus component?
If a column is missing in your excel file when using the Excel Source Plus component, your SSIS+ package will execute successfully, but we generate generate a warning message in the package event log. Please look at the screenshot below:Error message: Required object attribute(s) are missing from your request: row.id
Action: When updating a Smartsheet I get the following error message: Error Message: "Required object attribute(s) are missing from your request: row.id" Solution: To update the Smartsheet you need to provide the unique row identifier, ...