One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues. In this blog, we would learn about fixing another cause of script level upgrade for database ‘master’ failed.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
As they say – There are more ways than one to skin a cat. In this blog we will find another method to fix an error which you might see during SQL upgrades – Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission.
SQL Server Integration Services (SSIS) – There Was an Exception While Loading Script Task from XML
Recently one of my old clients contacted me for an error execution via SQL Agent Job. They informed that it runs fine when they invoke the package from Visual Studio (SSDT). In this blog post, we will discuss Exception While Loading Script Task from XML.
SQL SERVER – Huge Size of SSISDB – Catalog Database SSISDB Cleanup Script
In recent past, while doing Comprehensive Database Performance Health Check I encountered an interesting issue. In this blog, I am sharing my knowledge about how to clean up the SSISDB database using the script.
Before you try this, make sure you have gone through below blog to check the symptoms.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
As a part of my consulting, I see many clients who use SSIS. In this blog we would learn how to fix error “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”.
SQL SERVER – Unable to Run Maintenance Plan. Error: Integration Services Evaluation Period has Expired
A few days ago, one of my clients contacted me to fix an error which they were getting while using maintenance plan – Integration Services evaluation period has expired. Here is the complete error message which was taken from job history.