DTS with Activex & FTP & Email
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.