Error logging with Bulk Insert

  • Momhammad Atif

    SSC Journeyman

    Points: 95

    Comments posted to this topic are about the item Error logging with Bulk Insert

    Mohammad Atif
    Email ID : mohammad.atif1987@gmail.com

  • FortyEightK

    Mr or Mrs. 500

    Points: 553

    This is good info, and something I'll be applying to one of our BULK INSERT stored procedures. So many thanks for that.

    Where you mention constraints are disabled, it would be good info to also mention that any Triggers are also disabled in a BULK INSERT, unless you specifically set the table to allow them:

    ALTER TABLE [Tablename] ENABLE TRIGGER ALL

    This was a gotcha that had me scratching my head recently!

  • connect.akshay

    Say Hey Kid

    Points: 667

    Thanks Atif for sharing your knowledge. I am not able to grasp the ERRORFILE argument addition. Could you please elaborate of how to use it ? I am new to SSIS.

  • Momhammad Atif

    SSC Journeyman

    Points: 95

    Yes you are very true....Actually I was concentrating more on error logging so not mentioned that point in that post.

    Thanks.

    Mohammad Atif
    Email ID : mohammad.atif1987@gmail.com

  • Momhammad Atif

    SSC Journeyman

    Points: 95

    akshay.thanai (4/4/2013)


    Thanks Atif for sharing your knowledge. I am not able to grasp the ERRORFILE argument addition. Could you please elaborate of how to use it ? I am new to SSIS.

    @akshay...You are welcomed....Could you please let me know what exactly you are doing and what you want to know about Error Logging....also I have posted a seperate script on this website related to error logging....

    Please mention your requirement then I may be able to help you.

    Mohammad Atif
    Email ID : mohammad.atif1987@gmail.com

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply