Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes

SQL Server 2016 compress function details - external decompression

According to SQL Server 2016 docs COMPRESS and DECOMPRESS methods are just a blackbox I don't know what documentation page you are referring to but the COMPRESS reference states: This function ...
Dan Guzman's user avatar
  • 28.2k
3 votes

Migrating Azure SQL database to Azure sql Managed instance

The only way to go with this to get the bacpac file for your Azure SQL Database. Then import this bacpac file into your Managed Instance. This can be achieved through : SSMS Export\import using ...
Ramakant Dadhichi's user avatar
2 votes
Accepted

Azure Data Factory 'Failed Validation' with Folder does not exist

I had wrong file extension. Error message was misleading. Instead of cannot find file I thought the error was about missing folder. I had to change this "typeProperties": { "fileName": ...
SqlWorldWide's user avatar
  • 13.2k
2 votes

How to run legacy SSIS packages with Azure Synapse

SSIS IR support in Azure Synapse Analytics is now in preview: https://learn.microsoft.com/en-us/azure/data-factory/create-azure-ssis-integration-runtime You should still consider refactoring your ...
wBob's user avatar
  • 10.4k
2 votes

How to run legacy SSIS packages with Azure Synapse

Please, try to downaload the Azure Feature Pack for integration services. https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-...
MBuschi's user avatar
  • 4,535
1 vote
Accepted

How to call python file in repo in databricks from data factory outside DBFS?

For reference After all the mucking around, we decided to build a Python package (wheel) which can be imported to Databricks as a library. This can then be installed with %pip install /dbfs/..../*.whl ...
Brendan Hill's user avatar
1 vote

ADF patterns to minimise batch run elapsed time

Select data divided in groups evenly distributed by value This answer will help to distribute the weight into 4 workers. However, Each worker still has equal amount of jobs to execute. Modify it a bit:...
Andrew Pham's user avatar
1 vote

How to run legacy SSIS packages with Azure Synapse

as per documentation, SSIS packages now available to be run in Synapse via the SSIS Runtime available in the Management section of Synapse Studio. https://learn.microsoft.com/en-us/azure/data-factory/...
Peter O'Gorman's user avatar
1 vote
Accepted

How are tasks assigned to ForEach iterations

They are allocated round-robin, in the order they are produced by the Lookup. Although I can find no documentation to assert this, it is my observation. I can reliably reproduce it with a simple ...
Michael Green's user avatar
1 vote

Azure SSIS Deploying in SQL Azure

You will incur some expenses if you want to run ETLs (packages) from Azure. You can create Integration runtime via Azure Data factory and deploy package to the SSIS catalogue for Azure sql database. ...
Ramakant Dadhichi's user avatar
1 vote
Accepted

Stored procedure to set value to a column must accept returned values from functions

If it's possible to add an additional parameter to your stored procedure (PropertyValueIsFunction bit), you could test for that condition and use REPLACE to strip out the quotes. Here's an example: ...
Scott Hodgin - Retired's user avatar
1 vote
Accepted

What type of data ingestion does Azure Data Factory use?

According to the following picture found in the documentation, it has a Batch Ingest You could also use triggers to move data incrementally. But it is not real time. There is frequency limitation.
George Cernat's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible