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. Andyit is DT_CY http://msdn2.microsoft.com/en-us/library/ms141036.aspx
—————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
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
http://dineshasanka.spaces.live.com/
What is the service pack level on SQLServer in this case?
BOL does explain
quote:
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.
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
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ 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.
]]>