Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | SoftFoxStarting Member
 
 
                                        42 Posts | 
                                            
                                            |  Posted - 2008-05-19 : 09:27:13 
 |  
                                            | When using DTS to export from a view to a .csv file, is it possible to get it to export the column headers in the top row of the .csv file? |  |  
                                    | SoftFoxStarting Member
 
 
                                    42 Posts | 
                                        
                                          |  Posted - 2008-05-19 : 10:03:08 
 |  
                                          | Found it. Option is in properties of text source destination in DTS package. Tick "First row has columns." |  
                                          |  |  |  
                                |  |  |  |