SQL Server Performance

ID refering to table

Discussion in 'SQL Server 2005 Integration Services' started by avansa, Jan 20, 2007.

  1. avansa New Member

    I think I need som help as newbie...<br />I have a Fact table Purchase with different Purchase ID's. <br />In the OLE DB destination column I have a Demo_id which should refer to Dim_Demography_ ID which returns the characteristics as occupation, sex and salary from Dim-demography. How would I do that? <br />Now I have three choices in the destination Input column; occupation, sex and salary <br /><br />The OLE DB source sql command: <br />SELECT Sum, k.sum-p.price AS profit, convert (char(<img src='/community/emoticons/emotion-11.gif' alt='8)' />,date,112) as date_id, sex, salary, occupation, k.shop_id, k.customer_nr, salesperson_id, p.product_nr, campaign_id <br />FROM Purchase k join product p on k.product_nr=p.product_nr join customer ku on k.customernr=ku.customernr<br />
  2. satya Moderator

    SSIS help here is very thin, have you searched on any of MSDN SSIS forum sections in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page