Viewing 15 posts - 11,626 through 11,640 (of 13,879 total)
Yeah - that last line is trying to avoid inserting duplicates.
It says "don't insert lines where the userid already exists in the target table".
So if a userid has changed for...
February 10, 2011 at 9:45 am
Apologies if I'm stating the obvious here. It's difficult to go into any detail without knowing more about your systems - but your package appears to be failing as it...
February 10, 2011 at 9:19 am
Only the data has to change to create this problem... and I'm guessing that is not under your control. Or perhaps there is a problem where there are missing e-mail...
February 10, 2011 at 8:39 am
From the text of the error, I'd guess that you have a unique constraint on an EMAIL column and you are attempting to insert a record which violates the constraint.
February 10, 2011 at 8:06 am
Koen Verbeeck (2/10/2011)
Phil Parkin (2/10/2011)
Koen Verbeeck
- Da-Zero is dead! 🙂
The name is indeed, quite dead. I decided it was time to grow up and lose the nickname I invented...
February 10, 2011 at 7:48 am
Koen Verbeeck
- Da-Zero is dead! 🙂
February 10, 2011 at 7:36 am
SQLSmasher (2/10/2011)
One very common question asked by interviewers is:CAST versus CONVERT in SQL Server
That is not a question!
February 10, 2011 at 7:27 am
Use a data conversion transformation in the data flow.
February 9, 2011 at 8:54 am
Look harder at the word 'this' 🙂
February 9, 2011 at 6:39 am
So, in effect, you're trying to build a file-status table in memory and then issue a single commit at the end of package execution to write it to disk?
February 9, 2011 at 2:57 am
Koen (da-zero) (2/9/2011)
Stringzz (2/8/2011)
February 9, 2011 at 1:01 am
I agree, this seems puzzling. Is there anything in the Event Log?
February 8, 2011 at 10:18 am
Could this be relevant?
February 8, 2011 at 9:57 am
Viewing 15 posts - 11,626 through 11,640 (of 13,879 total)