DTS csv

Question

Post reply

DTS csv

mmatseke

Ten Centuries

Points: 1019
More actions
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

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

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

philcart SSC-Forever Points: 47794 More actions · Answer 1

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

mmatseke Ten Centuries Points: 1019 More actions · Answer 2

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

philcart SSC-Forever Points: 47794 More actions · Answer 3

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

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

mmatseke Ten Centuries Points: 1019 More actions · Answer 4

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)

philcart SSC-Forever Points: 47794 More actions · Answer 5

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

mmatseke Ten Centuries Points: 1019 More actions · Answer 6

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