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  | 
                             
                            
                                    | 
                                         Peter99 
                                        Constraint Violating Yak Guru 
                                         
                                        
                                        498 Posts  | 
                                        
                                        
                                            
                                            
                                             Posted - 2013-01-17 : 17:06:03
                                            
  | 
                                             
                                            
                                            | Hi,Imported DTS packages from sql server 2000 to 2008 r2. Installed sql server 2005 backword compatibility components as suggested by some other dba(s) at net.Installed sql server 2000 designer components, downloaded from microsoft web site.Changed path to set 2000 path first then 2008.Installed SP4 on backword components.Restarted computer.Can run dts package through job but not able to modify them by right click on them and selecting open.What is missing, any help?Thanks | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-01-17 : 22:55:41
                                          
  | 
                                         
                                        
                                          | seehttp://msdn.microsoft.com/en-us/library/ms143755(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |