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 bone-headed reason I was. In my case a better error message would have been:

SSIS error 0x00084005 "Hey, you forgot to declare your variables in the SELECT statement"

Whoops! Looks like cut and paste was the problem ­čÖé Here's to hoping all your problems are as easy to solve as this!

By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published. Required fields are marked *