For organizations relying on the SQL Server, Melissa's solutions directly integrate with SSIS, so the learning curve is minimal. You can drag and drop Melissa components in SSIS to validate, cleanse, append and enhance data.
2021-02-09
2021-01-14
46,092 reads
In this article we walk through the steps of how to run an SSIS package using SQLCMD along with passing parameters to the SSIS package.
2020-12-23
Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.
2020-12-14
Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.
2020-11-25
7,132 reads
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-12-31 (first published: 2020-11-24)
54,449 reads
This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]
2020-11-12
22,477 reads
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
2020-11-05 (first published: 2020-10-10)
2,902 reads
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
2020-07-31
Use T-SQL to analyse the usage of all variables and parameters in an SSIS project, including the identification of any unused variables and parameters.
2020-06-23
8,350 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Comments posted to this topic are about the item Writing as an Art and...
Comments posted to this topic are about the item String Similarity II
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers