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
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
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… Continue reading Scheduling SSIS Packages With JAMS: Simple Not Easy
If you're trying to export data in Windows to a UTF-8 format you may be wondering which code page you should use. Well the riddle is solved. Code Page 65001 is the equivalent of UTF-8. If you need to create an SSIS package to export data as UTF-8 for consumption by a unix system you should… Continue reading Which code page for UTF-8?
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… Continue reading SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)
While running a 2012 SQL Server Integration Services package, the package ended up failing with the following message: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender". The quickest and… Continue reading Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender
This article falls into the half baked posts category. Once I figured out how to compare two variables and then overwrite one with a script task in SQL Server Integration Services, I also realized I did not in fact need to perform the task. Doh! Still a useful bit of code though so I'm posting… Continue reading SSIS Compare Variables And Change One With A Script Task