Search results

This morning, I found myself adding some new columns to an existing dataflow that uses a Union All to combine data from 4 different SQL sources. It had been set up so all SQL statements produce the same columns, and I added some default fields to accommodate for the sources that do not have the...

A colleague of mine just ran into the following error: At the time he was copying some objects from one SSIS package to another, as he had been doing most of the day. However, all of a sudden this error popped up to ruin his day. He didn't actually try to save or do anything, but even just...

Our customer has requested the ability to have drill-downs in the cube, so we set those up in SSAS as actions. However, today she came and asked if we somehow capped the rowcount at 1,000 rows. Seeing I wasn't the developer who originally set the drill-through up, I got a bit worried, as...

If you ever renamed a column in a source table or view, you might have ran into the dreaded error: It usually means you need to refresh your data source view. However, you will need to ensure that any references to the particular column are also covered. Today, I ran into a situation where a...

This morning, I changed a few measure names in SSAS. Shortly after that, SSAS completely forze on me. I ended up having to end the process, and restart. When that was done, I was greeted with the error: As it turns out, the new name I provided for my measures was already used in a different...

Something I learned today is the ability to using named parameters when calling a function in C#. While writing T-SQL code, I always like to explicitly name variables, in order to provide transparency to whoever is reading the code. Compare this: INSERT INTO TableA SELECT * FROM TableB to...

After installing the RabbitMQ source components for SSIS, I created a test package to see if I could actually get any data returned. However, when running the package, I was greeted with the following error: This is because the RabbitMQ client dll that the connection manager is using has not...

When I first installed Visual Studio, I selected to use the Dark colour schema. This always worked wonders for me, until this morning I actually noticed that while running a package, the background of the package (data flow view) was white, and the row-count of the rows processed was also in...

We are trying to use the RabbitMQ components from GitHub. While attempting to do so, we ran into a few issues, so I figured I'd write a quick guide on what we did to get this to work. First, we downloaded the zip file, and unpacked it on my development server. Once it was unzipped, we opened...

We're currently working at a customer who have hundreds of SSIS packages making up their data warehouse. In the past, various developers have worked off and on on the solution, and the customer wanted to make sure that they had an overview of any SSIS packages that are executed in more than 1...

At a customer, I found out their tempdb was not as it should be. The server uses 4 CPUs, each with 2 cores. Common consensus seems to be that for every core, you ought to have 1 file in the tempdb. Their tempdb was fitted with 4 files. The other recommendation is to make sure all files in the...

We recently ran into an issue with Master Data Services (MDS) at a customer when we attempted to add our user accounts in order to access MDS. The error thrown was "No exact match was found". Initially, we assumed this could have been due to the fact our user accounts were relatively new at the...

Today, we ran into an issue when attempting to connect to MDS on our production server. MDS itself opened up fine, but when clicking on "Explorer", we were greeted with an ugly error message: The error message conveniently cannot be copied/pasted. As it turns out, this error was caused by...

Wouldn't it be nice if you could add some variables to your SSIS package, and use them throughout it? That way, if certain things, say, a file location, change, you will only have to change them in the variable, and not worry about editing multiple components. Normally this is exactly how you...

I ran across another minor issue with the Flat File Manager today. I set up a ForEach loop to go through all files in a folder, load them, and subsequently archive them. This uses a number of variables to set different parts of the process dynamically. When executing the loop, though, the...

Today, I had to source some csv files. So I set up a Flat File Connection Manager object, and configured it to deal with my file. The row delimiter was set to "Comma {,}", to fit the format of the source file. However, as it turns out, a number of the rows contained fields where end users added...

TLDR: You can use ISNULL when dealing with Pivoted data. I was working with data reflecting feedback our customers have given on how well we did in 3 categories. A customer can provide any combination of those categories (i.e. just 1, 2 out of 3, or all 3). In order to make the data easier to...

TLDR: When writing queries using the PIVOT function, the alias at the end of the pivot. Today, while working with the Pivot function, it took me a short while to figure out why my query was not working. My query looked just fine: SELECT foo, bar FROM table1 PIVOT (...

The other day I was slightly over-enthusiastic when closing tabs, and I ended up closing the tab I had been working in. Several hours of work lost, apparently, as because I had not saved my work, SSMS did not create an auto-save file for me. Luckily, though, I had been executing the query as I...

Today I attempted to deploy a database from my local SQL Server (SQL Server 2014) to Azure. Everything seemed to go well until the actual deployment stage. That failed, with the error in the topic. I retried, and instead of 'web' I picked 'standard'. I got pretty much the same error. Someone on...