title: SSIS Execute SQL Task Parameters - Works in dev, but not in prod. How to determine what's different between the systems?
body: <p>I have an SSIS package that passes three params to an Execute SQL Task. All three are varchar. When I run on a dev computer, Windows XP, Visual/Mgmt Studio 2005, it works great, params are passed and SQL executes. This however will not run on prod, Server 2008 w/ 2005 SSIS executables.</p>
  
  <p>To debug, I've simplified things down to a simple update command and a few alerts before and after the SQL task so show what values the variables are holding.</p>
  
  <p>What are some reasons that this would work differently between the two environments?</p>