On July the 22th at 9PM CET I will give the second part of the “Introduction to SSIS” webinar series on the MSSQLTips.com website. If you’ve never worked with SSIS before, it helps if you’ve seen part 1. The abstract: In this webinar, we build upon the Getting Started with SSIS webinar. You already know how to […]
Category: SQL Server
The GREATEST new T-SQL Function
If the title isn’t obvious enough, this blog post is about the new function GREATEST, and it’s sibling LEAST. But wait, how come there’s a new T-SQL function? There isn’t a new release of SQL Server! That’s right, those two new functions are released in Azure SQL DB, Azure SQL Managed Instance and Azure Synapse […]
#TSQL2sday 136 – Your Favorite Data Type
It’s T-SQL Tuesday time again, and this month’s honor to host the blog party goes to Brent Ozar. The topic is data types: Mad about money? Feverish about float? Tell us what you use your favorite data type for, and what people need to know before they get started using it. Data types have so many interesting […]
SSIS and the “ORA-00907: missing right parenthesis” error
I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query in Toad, where it executed successfully. I created my SSIS package, added the dataflow and an OLE DB Source component. I copy pasted the query into the editor and tested it using the preview. Which […]
Unable to validate source query in Tabular Editor
When you have a very large fact table in Analysis Services Tabular, you most likely have it partitioned. Suppose you are making some changes to the underlying source of the table and you hit “refresh table metadata” to add some new columns for example. What happens behind the scenes is that Tabular Editor will run […]
Upcoming Webinar- Introduction to SSIS
At February 25th March the 4th 2021 I’ll be giving a webinar on the MSSQLTips.com website. The topic is Integration Services. This webinar is meant as an introduction for beginners. The abstract: For years, Microsoft SQL Server Integration Services (SSIS) has been the tool in the data platform stack to integrate, move and transform your […]
Migrating SSIS to Azure – an Overview
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of virtual machines that will execute your SSIS packages. In the beginning, you only had the option to use the project deployment model and host your SSIS […]
Publish Database Fails – Script File could not be found
A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT and I tried to publish changes to the database on my local machine. I got a build error because I created a clustered index on the […]
Exporting Environment Variables out of the SSIS Catalog
Sometimes when you’ve created a SSIS catalog, along with folders, environments and environment variables, you want this content on another server. Unfortunately, you can only script out these objects in SSMS at the moment you’re creating them (thus right before you clikc ‘OK’ to confirm). Once the objects are created, you can no longer script […]
Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results on the first page were simply wrong. Most of them used this trick: Seems nifty, but they forgot about daylight savings time. If I run the […]