Search results

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

You'd have to provide us with the details of how the databases were created, preferably the actual script.

You ought to be fine. If my memory doesn't fail me, this only will grab the latest updates for SQL Server at the time of the installation process, and apply them at the end of the installation. Nothing more, nothing less.

I would use the Import/Export wizard to get the job done. Create a new database in SSMS, and then source it from your spreadsheet.

What error message do you get? Can you share the connection string (without the password or other sensitive data, obviously).

Hi Novita, This sounds like a problem caused by resource-heavy queries. If this is a trend, there are several solutions. I would start by doing performance monitoring, in order to determine what exactly is causing the bottleneck. Is it CPU, RAM, or Disk IO. Then, first try and see if you can...

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

Hi! Try and remove the double slash in front of the IP-address. I.e. just supplying 192.168.42.146\WIN-74DOGP6POB3 Hope this helps. If not, please show us some screenshots of how you're setting things up, and perhaps include the error message you receive. Thanks! /Peter

Suppose the following scenario happens. Finance sends you a list of invoice numbers and asks you to pull data on them. So you fire up SSMS, copy and paste in the list of invoices, and manually start adding start- and end quotes as well as commas around them. First row: Press Home to start at...

Learnt this today from a consultant, and since it's a quick little trick, I figured I'd share it. When you work in different environments, you sometimes want to test your query from DEV in QA, or from QA in Prod to verify the actual data. I used to copy the query to Clipboard, then connect to...

One would think that by default a server is configured not to automatically reboot after it installs updates. This is not the case, and I have encountered several cases where while I'm logged into a machine, it suddenly decides on its own that it's reboot time (Damn you Skynet!). Here's how to...

Certainly one of the most useful little tricks I recently stumbled onto is enabling line numbers in SQL Server Management Studio. How often have you looked at an error message that mentions a line, and then had to click at random spots in your code and then checked the satatus bar...

If you ever needed to pull data from Oracle using SSIS, you'll know it's quite a pain, and the process is rather slow. Your first struggle will be to figure out exactly which Oracle client you'll need. Chances are you run a 64-bit server. The problem here is that SSIS runs in Visual Studio...

At work, we use Google Analytics (GA) a lot. I recently came across a product that allows you to connect to GA from SSIS. However, at the time of writing, it is only a bunch of DLLs, and requires registering these in the Global Assembly Cache by means of gacutil.exe. My SQL Server did not have...