Tag Archives | Business Intelligence

SSRS: Parse parameters column from ExecutionLog

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 […]

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 […]

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 […]

SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)

As more and more companies are moving to heterogenous environments with both windows and unix systems the life of the Microsoft SQL Server developer is becoming much more interesting. For our recent data warehouse project I was asked to create a SQL Server 2012 Integration Services (SSIS) ETL package to output a text file for […]