Viewing 15 posts - 31 through 45 (of 62 total)
How do I get the identity column values from the errorPK table?
March 9, 2011 at 10:33 am
As you mentioned, the proc and trigger are equivalent in a bulk usage scenario. The trigger gets fired more often, though, depending on settings. The performance of the...
March 8, 2011 at 3:53 pm
vishal.gamji (3/8/2011)
Working on it.Although - shouldn't ssis be faster as bulk insert would be much faster than single row inserts?
Except that if you use fast load, and set the...
March 8, 2011 at 3:20 pm
Doesn't a trigger have the same performance of a Stored Procedure though?
And when I can make the trigger fire once after all my insterts is done, wouldn't this make the...
March 8, 2011 at 3:13 pm
That thread is talking about why the trigger wasn't firing at all. I know with fast load it doesn't trigger, which is why I specified the regular load.
What I want...
March 8, 2011 at 12:45 pm
I need to insert rows into the table I am referrencing too within the same package.
I need to insert rows into error table. Error table has an identity column primary...
March 8, 2011 at 12:17 pm
WHILE TestIsFalse
BEGIN
MoreLogicHere
WAITFOR DELAY '00:05:00'
END
March 8, 2011 at 11:22 am
Oh right ok, yeah the information is definitely there. I just needed to know how I can format it to be like:
Error Message | Column Causing Error | Value of...
March 3, 2011 at 12:00 pm
Yes that's what I am trying to get. What do you mean error path?
March 3, 2011 at 10:28 am
The value coming is not a string, is an interger. It gives me a data conversion error.
March 2, 2011 at 3:56 pm
This is perhaps a stupid question, but when you add a custom component, do you just need to add it on your computer or do you need to add...
March 1, 2011 at 5:27 pm
SQLkiwi (2/26/2011)
Khades (2/25/2011)
February 27, 2011 at 1:43 am
Viewing 15 posts - 31 through 45 (of 62 total)