Wowww. u solved my problem in no time.

Thank you so much for this much appreciated, it worked.

Many Thanks.

Many Thanks for your response much appreciated.

These are my two expressions, how would I combine then?

REPLACE([Column_name],"-","")

(ISNULL([Column_name]) ? "" : [Column_name])

Ok thanks. I did get this working thank you

I'm having the same problem and still can't get it to work

Can you send me the full connection string example please? I didn't get the link for more info?

E.g.

Name Address Phone Age

aaa bbb ...

Thanks for that its quite helpful. But difficult to compose when have 60 plus columns on the flat file. Please let me know if you know of any...

I do use data flow tasks but wanted to know how to get the bulk insert working for multiple files. I have created the dummies files thanks for the...

Hi Alan,

Thanks for your response. Could you possibly advise how you'd set the source connection in a bulk insert task that is within a foreach loop? If I...