-
help needed with DTS package....
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...
-
Basically yes, check details in books online.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|