Well, file this under "just because you can doesn't mean you should." Search the forums on parsing strings with Tableau and you'll find a lot of guidance which pretty much says "don't do it!" and "better to do it in your source!" These people are undoubtedly right. But, what if your source is an existing… Continue reading Tableau – Parse Parameters From URL
Ever worked on a quick little project, come across what you assume is a common need and think "I'll just google up some code that someone else has written and then be off to the races"? Have you done this and not been able to find the code you're looking for? Well, that was me… Continue reading SSRS: Parse parameters column from ExecutionLog
Man!!!! Why is the code to create a database snapshot so ridiculously complicated? Actually, I guess I understand why but how about allowing it to be done through SSMS and then setting a bunch of the parameters as defaults for us? Come on Microsoft! Help a SQL brother out! Well luckily, where Microsoft fails, I'm… Continue reading Easy SQL Server Snapshot Script / Proc
If you are looking to deploy your SSRS (SQL Server Reporting Service) reports directly from Visual Studio you will need to set the Target Server URL in the Properties of your project in the deployment section. The trick here is that this is not the URL for your Report Manager. What you are in fact… Continue reading Find Your SSRS Target Server URL
Don't you love how what should be a simple little tasks can become the most time consuming of the day? While trying to set up Visual Studio so that I could deploy directly to a development server I realized I would need the path to the SSRS ReportServer. Not the Report Manager mind you but… Continue reading How Do I Figure Out My SSRS ReportServer URL If It Is Not The Default?
Yay! There's a GUI to execute SSIS packages! Boo! It's really hard to figure out how to pass variables through it! You may have seen a message that looked something like this: TITLE: SSIS Execution Properties ------------------------------ DTExec: Could not set Package.Variables[User::MyVarA].Value value to Data Source=DevServ1. ------------------------------ BUTTONS: OK ------------------------------ Here are the three most… Continue reading How To Set Variables Using The SSIS Execute Package Utility
Here's a quick translation from SQL Server's T-SQL to Pivotal's MPP GreenPlum PostgreSQL for some of the most commonly used syntax (i.e. here's the stuff I've tripped over while moving from SQL to GreenPlum/Postgres) . SQL Server - TOP SELECT TOP 100 * FROM MyTable Corresponding PostgreSQL - LIMIT SELECT * FROM my_table LIMIT… Continue reading SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet
As soon as I saw this error message I guessed the problem was related to using a temp table. What was surprising was that the error message actually said this but I didn't realize it until by chance I cut and paste the message into another window. Look below: Do you see the reference to… Continue reading Troubleshooting: SSIS Unable to retrieve column information from the data source. Make sure your target table in the database is available.
This is one scary looking error message: SSIS error 0x00084005 "the parameter type cannot be deduced because a single expression contains two untyped parameters @x and @P1" It's terrifying enough to make you think maybe you should quit your SSIS development career altogether. But wait... What's this? Perhaps you're getting this message for the same… Continue reading Troubleshooting: SSIS error 0x00084005 “the parameter type cannot be deduced because a single expression contains two untyped parameters @x and @P1”
Dear SQL Server Integration Services Team, Would it be possible to get a more specific error message than "There are some mapping errors on this path"? Your friend, Phil The tricky problem with this error is getting enough information to troubleshoot it. Here's a nice trick for you: Run the package. Wait. What? Why would… Continue reading SSIS: There Are Some Mapping Errors On This Path – Troubleshooting