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  | 
                             
                            
                                    | 
                                         rad14i 
                                        Starting Member 
                                         
                                        
                                        4 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2012-03-30 : 11:01:08
                                            
  | 
                                             
                                            
                                            | Hello,Do you have any idea which one is more efficient, better and faster?SSIS,Linked server, BCP commandsor do you think any other method?Thanks | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2012-03-30 : 17:42:11
                                          
  | 
                                         
                                        
                                          | whats exactly are you trying to do? import data from file, export data to file or something else? is the file consistent in format? is it stright transfer of data without any intermediate logic/transformations?we certainly need a more detailed picture for suggesting anything.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |