Results 1 to 13 of 13

Thread: MS SQL Question

  1. #1
    Join Date
    Mar 2004
    Posts
    84

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    169
    Have a look at DTS. It is designed to do the process you are doing.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  4. #4
    Join Date
    Feb 2003
    Posts
    1,048
    I prefer using xp_sendmail over SQLMail. Using CDOSYS seems like overkill.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  6. #6
    Join Date
    Feb 2003
    Posts
    1,048
    Excellent points.

  7. #7
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Mapi is not cluster aware. So SQLMail cannot be used in SQL Cluster.

    SMTP/CDOSys.... can be done

  8. #8
    Join Date
    Feb 2003
    Posts
    1,048
    I have no problems using SQL Mail in a cluster.
    Last edited by Rawhide; 07-15-2004 at 12:31 PM.

  9. #9
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    SQLMail cannot be used in SQL CLuster.

  10. #10
    Join Date
    Feb 2003
    Posts
    1,048
    I meant to say that I have had no problems using SQL Mail in a cluster.

  11. #11
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It works but it's not cluster aware application, that means if the SQL Server fails over to another node, SQL Mail will not.

  12. #12
    Join Date
    Feb 2003
    Posts
    1,048
    That's considerably different than "can not use it in a cluster then".

  13. #13
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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
  •