Post reply

DTS csv

  • May 19, 2004 at 1:04 pm

    #59710

    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

  • May 20, 2004 at 9:04 pm

    #507216

    Is this the entire query? Do you have other tables joined or a WHERE clause?

    Can you put the query into a stored procedure and use the stored procedure as your source?

    What version and service pack are you using?

    --------------------
    Colt 45 - the original point and click interface

  • May 21, 2004 at 12:33 am

    #507226

    This is a stand alone table it is not linked to anything.  Please try to create this table and select from it and output it as a .csv

  • May 21, 2004 at 12:52 am

    #507230

    Ok, if you could provide the datatypes I can try it.

    --------------------
    Colt 45 - the original point and click interface

  • May 21, 2004 at 1:10 am

    #507232

    Thanks, here we go

    trad_type char(20),

    reference char(20),

    principal char(20),

    book char(20),

    strategy char(20),

    cpty char(20),

    buy_sell  char(20),

    Quantity numeric,

    ident_type char(20),

    ext_ident char(20),

    sec_name char(20),

    price int,

    price_divisor numeric,

    traded_net_ind char(20),

    trade_ccy char(20),

    trade_ldt smalldatetime,

    value_date smalldatetime,

    commission char(20),

    exchange_fee char(20), --Dont worry about fees being char

    other_fees char(20),

    gross_consid numeric,

    net_consid char(20),

    sett_ccy char(20),

    trad_sett_ccy_xrate char(20),

    trad_sett_ccy_xrate_mdv_ind char(20),

    trad_inst_ccy_xrate char(20),

    trad_inst_ccy_xrate_mdv_ind char(20),

    pb char(20),

    acct int,

    inst_class  char(20),

    cont_desc char(20),

    pl_book_ccy_xrate  char(20)

  • May 21, 2004 at 1:31 am

    #507234

    Ok, I created the table, built a DTS package, put the select query into the source and successfully ran the package.

    What options have you used for the csv file?

    --------------------
    Colt 45 - the original point and click interface

  • May 21, 2004 at 1:56 am

    #507239

    I uded the defaults, Send me your empty private mail @ msenoelo@investec.co.za so that i can email you the .gif

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply