Deploying tabular model to different environments via Dev Ops
Hi guys, I have an issue deploying of xmla model using DevOps to production server. The release pipeline connects to AAS instance and run a query of createOrReplace type. When this step is done on development aas server it works fine but when I try…
Replace some characters within an Excel file via ADF v2
Hello, we have a below architecture wherein: Excel file in blob >>> ADF v2 to convert it into CSV file >>> Azure synapse(polybase) Now the challenge is ADF v2 supports only single delimiter and in case if that delimiter is already…
SQL Server SSIS package performace issue
Hello All, Using SQL Server SSIS package Trying to export MS SQL table data into oracle table it is taking 1hr for 50 lac row (Table Name - EMP, Column ID, and Name) For the same table SSIS IMPORT taking only 1 min. I need help or suggestion how…
SSIS Source Control Azure Dev Ops Git repo help
HI All. I have recently moved an SSIS project from VSTS into an Azure DevOps git repo. The project is a simple one with a master package calling several child packages using "Execute package Task " with reference type = "Project…
dynamics 365 web api SdkMessageProcessingStepRegistration usage
Hello, I'd like to get some help on the usage of SdkMessageProcessingStepRegistration that is described 1 Is there anyway to make use of it via Web API? Thanks
SSIS OData conn parameterized
Hello, I am having some trouble parameterizing an OData connection to sharepoint. I created an SSIS package that gets a list from sharepoint. I am using an OData conn manager, the auth type is Microsoft Online Services. In VS2019 I provide the…
Attunity CDC for Oracle OCI_FETCH error
We have setup Oracle CDC by Attunity in a SQL server 2016 environment. From the Designer everything runs fine until an actual change happens in one of the included tables in the Oracle database at which point the operation aborts. When looking at the…
Problem with my OLDB source (Error with the AquireConnection )
Greeting all , while the daily refresh of my data source , i found this error in my SSIS , anyone faced such thing please ? Thanks in advance .
Exchange 10 to Exchange 16 Migration: What about distribution groups?
Hi there i got another question regarding the migration of Exchange 10 to Exchange 16... Both Ex'es are in "tandem" mode and everything; inkl. the public folder access via Proxy Mailbox on the Ex 10; seems to work fine. Now what about ....…
SQL Server Login Auditing
Hi, Is there a way to check the active audit level setting on a SQL Server since it can be changed multiple times without restarting the service. This is Login Auditing in Server Properties. Via GUI or reading the registry tells me what is set but…
Excel 2019 Formulas change. What am I doing wrong?
In Excel 2019, I have a master Sales file that auto feeds information from all 5 stores monthly sales excel spreadsheets. When i open up a store Sales spreadsheet and then open my master Sales spreadsheet, after i click update on the master, all the…
Azure Devops feed - username and password - 401 error
I have setup devops feed - for python twine/pip - with myself as owner. if I try to run twine upload - and enter the credentials that I use to log in to azure portal - then i get a 401 Unauthorized error. followed the instructions in the 'connect to…
Windows 10 not shutting down HP Envy Laptop Model 13-aq0000na
Hi New HP Envy laptop running Windows 10 fully up to date on patches is no longer shutting down just hangs on the “Shutting Down” splash screen. If I try restart same issues just hangs on restarting splash screen. I cannot work out what process is…
Exchange 2016 - Application getting 4.5.2 Too Many Recipients error
We have a third-party application that is sending out emails to our users via a scheduled task, and it's reporting a server response of 4.5.2: Too Many Recipients when trying to send them out. The email was being sent to 421 recipients. Our Exchange…
Requested value SchedulingMailbox was not found (Hybrid Exchange 365+Exch2010)
Hi guys, suddenly i'm receiving an strage error when i try to list the accounts that were migrated to our 365 tenant on my EXCH2010 console. I've already tried to empty the migration batch on exchange administrator online. It only list a few…
Active Directory problems, replication. Help!
Hello: After the "typical" domain lost connectivity error between two domain controllers in different sites (with I dont know if lingering objects), after trying an autorithy restore (D4 in the main site and D2 in the secondary), and after…
Logic App Execute Query fails to connect
Hi, After trawling the forums and Docs I cannot find a reason for this failure, but I have a couple of ideas but need guidance. My stored procedure executes fine from SQL Server Management Studio. My Logic App runs fine apart from when it runs…
Setting Up Alternate Access Mapping: Another internal URL for an existing web app - SharePoint 2019
Hi, I am starting to work on SharePoint after a long gap (almost 4 yrs) and was trying to do a very simple thing - Setting up an Internal URL for an existing webapp using Alternate Access Mapping. In other words planning to have a different internal…
How to "Performance by Exam section" details displayed just after AZ-900 exam?
I have appeared the AZ-900 exam and after the exam the progress report "Performance by Exam section" shown on the screen. I thought it will also available after the exam some where but could not find the same. Is there any way to get that and I…
Why don't CD-RW discs have write protect option?
Why don't CD-RW discs have the write-protect option? Is it hidden in some operating systems? I need to know this. I have Windows 10 home edition, and it won't have the write protect option when I put a CD-RW disc in. Regards, JohnCTX