Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: DTS to output .csv

    I am selecting the following fields from my table and drop them into my .csv, the problem is that if i select all the fields which I commented out, and click on define columns, populate from source, execute, then on the Destination Tab, none of my columns are selected, it is blank, please help, here is my table

    select
    trad_type,
    reference,
    principal,
    book,
    strategy,
    cpty,
    buy_sell,
    Quantity,
    ident_type,
    ext_ident,
    sec_name,
    price,
    price_divisor,
    traded_net_ind,
    trade_ccy,
    trade_ldt,
    value_date,
    commission,
    exchange_fee,
    other_fees
    gross_consid,
    net_consid,
    sett_ccy,
    trad_sett_ccy_xrate,
    /*trad_sett_ccy_xrate_mdv_ind
    trad_inst_ccy_xrate
    trad_inst_ccy_xrate_mdv_ind
    */
    pb,
    acct,
    inst_class
    /*cont_desc
    pl_book_ccy_xrate
    Id*/
    from Table1

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face DTS to Output .csv

    Use the sql analyzer to get the list you want. Copy the list to a spreadsheet and change the file type. Or, create a temp_table and select into the temp_table.

  3. #3
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71
    I still get the same problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •