Okay thanks

This is what I had tried:
SELECT Dph_index, file_no, phone_no UNION ALL SELECT Dph_index, file_no, phone_no FROM

Yah I seen a lot of people on line had that, and I tried it and but is then says that the BCP failed

Thanks the link helped I got it to export, but for some reason it does not include the column names, Any idea what I can do there?

Thanks but I tries that as well as other options and I still get the same thing, but thanks for your help, and I look at the link you  provided.

Thanks this really helpful so you save the scripts.
What can I do to save view, triggers, security, objects and other things like that, incase my server goes down ?

Hi,
Thanks I did not realize that I had to save the file as an  ISPAC file....

I right clicked on the project in SQL Server tree on the node marked Intergration services; and exorted it out. I then tried to add it in SSIS.
The version...

Hi and thanks for the reply.
 just see a lot of stuff like this:
PK   ^ëL/¢Þ›f  |x  & upkgRefreshValidationDataOnPortal.dtsx ¢ (                      í]ísÚ8ÿ|7sÿƒŽOÏÍ…wHHÜðbZ®y‡ôÚëu:ÂÁ©±]KNBŸ¹ÿýYI0ØI 
When I open it in note...

Hi and thanks again for your replies. Sorry, I did not understand what you wanted when you said you needed more information; I should have thought of scripting it for...

Thanks for the replies, I thought of the order by and I know that there really is not a guarantied order but with out an order by this is how...

Sorry I unfortunately would not be able to do that since it is private data.
 can tell you that I have the following 
--> between words and 
_ -->...

Yes I was able to do this with SSIS so I know it is good. The problem is I am going to run this from a VB.Net application and calling...

t's empty in the input file

Thanks guys this all really helps