SSIS variables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSIS variables

Does anyone know what datatype in SSIS is equal to SQL Servers smallmoney? I have a sql task and I’m trying to put my result set (a smallmoney SQL Server datatype) into an SSIS variable, but there is no SSIS datatype for money or decimal. Andy
it is DT_CY
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

I’ll take a look. Thanks for your help. For now, I am passing the value in as a string and then converting it in a stored proc that I use later on. Andy
Dineshasanka, I do not have any of these data types listed in the drop down menu in the variable section in SSIS. I have Boolean, Byte, Char, Datetime, DBNull, Double, Int16, Int32, Int64, Object, SByte, Single, String, Uint32 and Uint64. Any ideas why I have a completely different list than the link you provided? When I add a variable, I go to SSIS at the top in the toolbar, then Variables and click the add variable button. Is there another place to add variables that might include the list you provided in the link? Andy
Dineshasanka, If you click on the link in the article, Mapping Data Types in the Data Flow, you will see the list I emailed above. I do not see a smallmoney data type in the list. These data types are the only ones that I see when I try to add a variable. Maybe it’s just an oversite in SSIS… Andy
DT_CY is avalible in Type cast functions or variables. I think you are correct it is not there in SSIS variables.
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

What is the service pack level on SQLServer in this case?
BOL does explain
These mappings are not intended to represent strict equivalency, but only to provide guidance. In certain situations, you may need to use a different data type than the one shown in this table.

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.