Databricks not recognizing updated Service Principal Secret

Problem One way of authenticating Databricks APIs to Azure platform is using a service principal with permissions on Azure AD. In case a client secret is chosen for authentication, Azure forces an expiry date on the secret. When the secret expires the Databricks loses visibility to Azure with an error like below. This error can … Read more

Return Value in SSIS OLE DB Command

Problem In SSIS, OLE DB Command is used as a part of Data Flow to run SQL codes to transform data. Is it possible to use one of the parameters as a return value? Solution Returning values in SSIS OLE DB Command task is possible but the limitation is you can only return one value … Read more