If I have an executesql task that returns a result set, if the result set contains a tinyint, I can't find what SSIS data type to declare the variable as. They all cause errors.

Answered my own question have a look at my post http://www.sqljunkies.com/WebLog/simons/archive/2006/02/24/tinyint_in_SSIS.aspx [2009-10-03] The blog above has moved the link should now be http://sqlblogcasts.com/blogs/simons/archive/2006/02/24/SSIS-data-flows-and-tinyint.aspx

This link does not work any longer. I having the same problem tinyint to SSIS data type and could use some assistance. Thanks!

I would imagine that you would have to wrap the SQL in a "CAST(x AS INT)", then use an Int32 SSIS type.

Trying to avoid this casting. I will also be writing this variable to the table which has the column defined as a tinyint. I would imagine there might be some problems doing that too if it cannot be handled as a tinyint dt in SSIS.

The link should be http://sqlblogcasts.com/blogs/simons/archive/2006/02/24/SSIS-data-flows-and-tinyint.aspx

Thanks. The article seems to indicate a data type of DT_UI1 (single byte un-signed integer); However, I do not see that variable type in the Data Type drop down for SSIS package variables. Did I miss something?

Try Byte. One of the great things about SSIS is the numerous lists of data types

Byte does not work either, at least in 2005, so holen1Master's original question is still unanswered. If you are trying to assign a tinyint value from a sql result set to an SSIS variable, there is no compatible SSIS variable