-
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…
-
It all comes back to the work that occurs behind the curtain…
Couldn’t have said it better… RT @lanier: “80% of #datascience is infrastructure; 20% is the fun stuff—charts etc.” – @opower at #strataconf — Michael Cavaretta (@mjcavaretta) October 24, 2012
-
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…