I would like to create a TAB file "category.txt" with the header - categoryid categoryname parentid categorydescription categoryimage categorybottomdescription categorydisplaytitle categorydisplayordergroup pageDescription pageKeywords
FROM a SQLQuery Result - SELECT * FROM tblcategory.

I would like to create a DTS package so I can automate the process of creating category.txt file.

After creating the category.txt file I would like to ftp it to the different server. And send an email of completing the job. I would like to automate/schedule every night this process.

Would it be possible for me to do?

I would really appreciate your help. Thanks in advance.