thanks you so much for the help!!

Thank you...

Thaks for your answer Tim,

  There are more than 20 Tables and  all foreignkeys are setup for "NO ACTION".... ouch

We are taking the long road to delete all the foreign...

Ok got it, I just added the text to the select statement,

select tbl.name, 'static text'

I works for my apllication.

Cheers

So i pop the select case statement directly into my query?

Well thank you very much... it could not been easier...this will same me tons of time, before i would massage the data in excel...ouch! Just one more question. Say we...

Hmm, nope I did not specify any lengths in the destination text file, I will have to investigate that and see how I am going to go about doing that.

Thanks...

Ok, I ran the query and exported it to a fixed width text file. Now, when i view the text file with notepad++ this is what I see;

Joe.........Smith.........12.somewhere.street...............crlf

query:

SELECT convert(char(9),sa.fname), convert(char(9),sa.lname), convert(char(15),sa.address)

FROM...

Ah ok, then the fix length output in DTS will preserve the field lengths. I will give this a try and see how it works out.

Thanks

duh!!

It should be like

Select

convert(char(9),as.fname), convert(char(9),as.lname), convert(char(9),as.address)

FROM

Is this the correct syntax?

Hi,

Tnx for reply, If I understand this correctly then after my select statement i then insert the convert statement, so if I have multiple fields I will instert multiple convert...