I answered myself.  The problem is I didnt pu ID as Primary Key or Unique Constraint.  Thanks

Thanks, this works perfect

I created the table myself and i have all the right.  The other thing is if i call column names eg FA, FB and the likest, I can select everything and...

Everything you explained, is what i have done, the problem is, the columns do not get populated to the destination, so basically my destination is empty, but if i select...

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

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...

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

Thanks very much, it worked!

This is not working because your code gives me the date as 2003-05-03 and this is a Saturday, I am expecting the results to be Monday since I am only...

I am not sure if i understand you, you meena my query must look like this correct me if i am wrong because this is not working

create function fn_NextTrDate(@TrDate datetime)

returns...

Sorry about this Mike but this doesn't work in the following cases

If I use TrDate = '2003-04-25' and I add 7 which is the 2 May 2003.  2 May 2003 was...

Hi Antares686

I thought you everything which Mike did is working fine, the only problem is the dates.  I need help on how...

Hello Mike

Thanks a lot for your help but I have a small is problem

My data type is a problem, TrDate is saved in the format 2003-04-24 11:27:56.000 where as my Holiday is saved as 2003-04-24...

Maybe let me re-phrase my question, i need to retrieve the server, username of the their connection in the DTS-Package.  That is if the Connect into SQL sever, i need...

Hi Grasshoper.

Please send me the script