sql - Need suggestions on what tool to use for manipulating a file -

we have need create daily process manipulate file being manually generating before ftping vendor. issues current file follows:

1) comma delimited , needs pipe delimited.

2) vendor want specific columns sent. have limit of 26 columns.

we need develop automated process can scheduled run once day , pick file specific extension, file manipulation , ftp file.

ideally, have error handling in process. want email sent out if there no file process or if there error during manipulation or ftp process.

my first thought use sql server import/export. i've done before packages run manually. process needs automated (after existing file manually generated.) don't see way pick file specific extension. looks have select specific file. there way use import/export or similar tool? or, need write program sort of task? seems me more work write program. so, trying avoid that.

thank help!

you should write program. seriously.