April 4, 2013 at 12:00 am
Comments posted to this topic are about the item Error logging with Bulk Insert
Mohammad Atif
Email ID : mohammad.atif1987@gmail.com
April 4, 2013 at 2:49 am
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!
April 4, 2013 at 10:05 am
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.
April 5, 2013 at 10:02 am
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
April 5, 2013 at 10:08 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply