SQL Server Performance

SSIS variables

Discussion in 'SQL Server 2005 Integration Services' started by andyrussell_10, Jul 10, 2007.

  1. andyrussell_10 New Member

    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
  2. dineshasanka Moderator

  3. andyrussell_10 New Member

    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
  4. andyrussell_10 New Member

    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
  5. andyrussell_10 New Member

    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
  6. dineshasanka Moderator

    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/
  7. satya Moderator

    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.

    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.

Share This Page