Tag Archives | SQL Server Integration Services

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

Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender

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

Create a MessageBox in SSIS with C#

What is wrong with me?!?  Or rather what is wrong with everyone else on the internet?  Why won’t anyone post a little article on how to create a message box in an SSIS package so I can easily google it?  Must I do everything around here? Confession: I don’t know jack about C#.  Creating a […]

SSIS Compare Variables And Change One With A Script Task

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

SSIS: No column information was returned by the SQL command

Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task?  If your stored procedure contains a temp table you may run into the message “No column information was returned by the SQL command” (complete error message below).  Although there are a number of solutions […]