-
MS SQL Question
Hi All,
I receive files from the FTP and
I have a process running from the command line that renames the files, copies them into one file to be used by bulk insert and runs the bulk insert to populate the table in the database, then it runs the store procedure to clean up the data in the files. The store procedure has the error checking on every transaction. I have tested the error checking and it is working, but once the error occurs I also have to stop the process that is running on the command line and send an email and a page to me to notify that there is an error. I did a lot of research, but couldn't find anything that was helpful to me. Please help. Thanks.
-
Have a look at DTS. It is designed to do the process you are doing.
-
DTS allows you to branch into different path based on job completion, success or failure.
For emailing part you can use SQL Mail but I prefer using a simple VBScript to use Windows CDOSYS object and send email using a SMTP server.
-
I prefer using xp_sendmail over SQLMail. Using CDOSYS seems like overkill.
-
SQL Mail needs Outlook client in the server and in many organization it is a No No.
Also SQL Mail is not stable. If it stops for any reason, you have to restart the SQL Service to get it working.
-
-
Mapi is not cluster aware. So SQLMail cannot be used in SQL Cluster.
SMTP/CDOSys.... can be done
-
I have no problems using SQL Mail in a cluster.
Last edited by Rawhide; 07-15-2004 at 12:31 PM.
-
SQLMail cannot be used in SQL CLuster.
-
I meant to say that I have had no problems using SQL Mail in a cluster.
-
It works but it's not cluster aware application, that means if the SQL Server fails over to another node, SQL Mail will not.
-
That's considerably different than "can not use it in a cluster then".
-
what is the point in using a non cluster aware mapi in a cluster server?
wait for Yukon.
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
|
|