-
SSIS: Parsing a connection string using an SSIS expression
Sometimes, the things we do can seem a bit convoluted. This is one of those cases. Without bothering to explain how we got to this point (a long story with an uninteresting ending), I will explain how to use an SSIS expression to parse a server and database name out of a connection string stored […]
-
How To Set Variables Using The SSIS Execute Package Utility
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 […]
-
SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet
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 […]
-
Troubleshooting: SSIS Unable to retrieve column information from the data source. Make sure your target table in the database is available.
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 […]
-
Troubleshooting: SSIS error 0x00084005 “the parameter type cannot be deduced because a single expression contains two untyped parameters @x and @P1”
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 […]
-
SSIS: There Are Some Mapping Errors On This Path – Troubleshooting
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 […]
-
Scheduling SSIS Packages With JAMS: Simple Not Easy
Scheduling SSIS packages to run via JAMS can be pretty tricky (especially compared to the plug and go of scheduling SSIS with the SQL Server Agent). Here are a few tips to get you started. Create a command line dtexec for your package to confirm all your parameters and syntax is correct. I like to […]
-
Convert CamelCase to Underscores using SED and tr: GreenPlum MPP Refactor
All of our SQL Server databases use CamelCase as the naming convention. Unfortunately, GreenPlum MPP does not support CamelCase (without the use of quotes that is). Since I was transitioning a table from SQL Server to GreenPlum MPP and because I’m becoming a bash wizard (ha!) I wondered if there was a simple way to […]
-
Data Modeling Tools Are Living In The Past: Your Best Bet
It’s been awhile since I actively used a data modeling tool as part of my development process (three years since I even had one installed). My experience had been that almost all of them could make perfectly acceptable models by reverse engineering an existing database, but none of them accelerated the development process in an agile […]
-
GreenPlum MPP Tool Review: Navicat For Postgres
I’ve spent a few hours so far working with Navicat for Postgres connected to our GreenPlum MPP (Massively Parallel Processing Database). (pgAdmin continues to iritate me but it’ll be hard for a competitor to supplant the free incumbent). There is definitely some solid functionality here. Pros: Performance – The UI seems to be balzingly fast […]