What type of text file Is that comma seperated or tab seperated or text with headers ?

EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT

IF @OLEResult <> 0 PRINT 'Error in Scripting Object'

--Open a file

execute @OLEResult = sp_OAMethod @FS, 'OpenTextFile', @FileID OUT, @file_name, 8,...

This can be easily achieved using SQL . Do you need the code snippet ?

Sorry, I did not notice of the fist comment. This can be easily done in using SQL.Do you need a code snippet ?

Do you need to create text file from sql and push them to FTP ?