help needed with DTS package....

[raaj]

Hi guys,
I am new to using DTS..so can any one let me how to do the following scenario...

I am having a file which is encrypted on the server and i have already written a query to decrypt that file.so when i run tht query which i have i will get a txt file with the decrypted matter in the specified location.
Now i want to write some DTS package which does the above process and if the query which i run is successful then text file is produced with decrypted matter and a mail should be sended saying success else a mail should be sended saying failure....

here is what i am thinking to do-----
open new package-->bring the connection--->drop sql task and wite the query in it-->use 2 send mail task one for success and one for failure.

is that the correct way???
any suggestions would be really appreciated....

raaj...

[rmiao]

Basically yes, check details in books online.