Search results

I was working on an SSRS report today. It's a fairly straightforward process; select a data source, paste in a query, and click "Next". Not with this report. The error in the title popped up for me. It's a pretty non-descriptive title, though, so I popped open the Query Builder, hoping to find...

This is as off-topic as things might get, but in my spare time I enjoy reading. One series of books that I love dearly is the Discworld series by the late Sir Terry Pratchett; a man whose writing skills and sense of humour were on a completely different level. In the series, onbe of the main...

Scrapy is a web-scraping library for python. Installing it (once Python is installed) is fairly straightforward. First of all, we'll have to install pip. Pip is a package manager for python. The easiest way to obtain it is by saving the following page to your local computer (like, for instace...

If you are going to be using third-party (or your own) DLLs from inside SSIS, you will have to ensure the DLL is registered on your target server(s). This article is meant to describe how to do this. First, find the DLL you need. For the sake of this article, let's assume we have grabbed a copy...

Recently I wanted to know which of my packages contained SQL that referenced a specific table. I ended up copying all packages to a folder, and painstakingly performing a text-based search in the files to find the table in the script. Today, a colleague showed me this is actually possible...

Hi Grand, What dlls are being used by the VB Script? What does the script do? Could you show the code? Thanks! Peter

This morning, I noticed my local installation of SSAS was complaining it didn't recognize my user account. This is probably because it's been quite a while since I logged on to the corporate domain, and I suspect my token expired. In SSAS this manifested itself by my userid being replaced with...

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...

Hi Peru, What exactly is causing you issues? Easiest way is probably using the GUI in SSMS, but otherwise, use a CREATE DATABASE statement.