the formatting happens in a derived column before it hit the database.

I didn't set it up like this. this is how someone else built the package and I don't want...

datetime

I write it to an sql database table

o ya forgot I could do it there

thanks for that

ya was getting errors and I used a datagrid view to look at the data but this fixed my problem

ISNULL([Fixed Rate]) || [Fixed Rate] == "" ? "0.00" : [Fixed...

its coming from text file so its a string

CREATE TABLE [dbo].[BNYPortValInbound](

[PK_ID] [int] IDENTITY(1,1) NOT NULL,

[Country] [nvarchar](128) NULL,

[InvestmentType] [nvarchar](128) NULL,

[AssetType] [nvarchar](128) NULL,

[SecurityName] [nvarchar](128) NULL,

[CouponRate] [nvarchar](128) NULL,

[SecurityID] [nvarchar](128) NULL,

[MaturityDate] [datetime] NULL,

[HoldID] [nvarchar](128) NULL,

[CounterPartyRef] [nvarchar](128) NULL,

[Custodian] [nvarchar](128) NULL,

[MarketPrice] [decimal](15, 4) NULL,

[Currency]...

thanks for the help. changing the file to text delimited its working fine now

ya use them to no difference. its grand the client will just have to use tab delimited text files going forward if they are going to have bad data all...

iv tried them all they don't seem to work. I have colons and semi colons in some fields so cant use that. when I try tab or vertical get an...

its not a single column there is 20 columns in the file. I can see why its causing the error. on the column delimiter its set to comma(,)

if I try...

its a csv file and in the csv file is all in the 1 column so should be split out correctly

its seems it has been slpit out before it reaches my replace.

I have a flat file then the replace. but after I read the falt file its like this

Counter Party...

anyone any ideas on this. need to try get this sorted this week if possible

every column in flat file has a coulmn connected to it in the db table.

and i have actually made a mistake. they way i was doing it is i read...