SQL Server Performance

Data type Decimal does not like the point in (2007.08) workaround? Set Input data Type for Parameter(Long etc.)?

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Aug 6, 2007.

  1. Ismailc New Member

    Hi, I have to create a variable period but it does not like point in data type decimal (2007.08)
    DTS 2000 Variables.
    Period Data Type: Decimal Value: 2007.08
    DateFrom Data Type: Integer Value: 20070801
    SplitFactor Data Type: Real(8 Byte) Value: 0.88
    SSIS Variables
    Period ? (string)
    DateFrom Int32
    SplitFactor ? (string)
    Any Ideas?
    What to I set my input data Type for a parameter (Long etc.)?
  2. Ismailc New Member

    Again Me.
    I set the global variable period data type to string and then in the task Parameter mapping Data Type to LARGE_INTEGER

Share This Page