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 |  
                                    | smp2001inStarting Member
 
 
                                        2 Posts | 
                                            
                                            |  Posted - 2008-05-01 : 16:45:41 
 |  
                                            | Hi..I am in a urgent need to know how to export/upload a txt file to and FTP Location, using DTS. URGENT PLEASE.Thanks nitin |  |  
                                    | tkizerAlmighty SQL Goddess
 
 
                                    38200 Posts | 
                                        
                                          |  Posted - 2008-05-01 : 16:47:36 
 |  
                                          | Have you checked out the FTP task in DTS?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |  
                                          |  |  |  
                                    | smp2001inStarting Member
 
 
                                    2 Posts | 
                                        
                                          |  Posted - 2008-05-01 : 21:00:10 
 |  
                                          | Hey in FTP Task...it only allows to download the file but for the upload of the file that TASK doesnt work..anyother idea pls... |  
                                          |  |  |  
                                    | rmiaoMaster Smack Fu Yak Hacker
 
 
                                    7266 Posts | 
                                        
                                          |  Posted - 2008-05-01 : 21:45:52 
 |  
                                          | You can run dos command or batch file in dts. |  
                                          |  |  |  
                                |  |  |  |