May 30, 2007 at 12:06 pm
I have a table which gets populated from a flat file. On this table I have an insert trigger which checks for any null values on few columns when data gets inserted. I see that the trigger isnt getting fired when DTS runs although the flat file has some null values. If i try inserting data form backend th trigger works. Is there any limitation in DTS which avoids that check/ Any help on this will be greatly appreciated.
TIA
May 31, 2007 at 7:19 am
If you defined a bulk load in your DTS package it may bypass the trigger. But why do you have a trigger to look for nulls? What do you have defined in you DTS package.
May 31, 2007 at 8:21 am
My Dts have a a flat file with a sql server connection and data gets loaded using transform data task. Whats the best approach to check for null values? I can have a 'not nullable' column but when a null value exists in flat file i need an email notification saying that data is null. Is this something doable?
May 31, 2007 at 8:24 am
If you are going to load anyway why not forgo the tirgger and have the dts kick of a check process afterwards looking at the loaded data. As for why your trigger isn't working try adding a RAISERROR item to the trigger to see if the trigger is not actually fired?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply