Use SUBSTRING instead of LEFT to achieve the same thing.

It would seem not. But have a look here - someone has already written it for you.

Good luck. Now the fun bit starts. I suggest that you start with a source file containing just 10 lines or so to speed up your development.

Thanks for posting back - that's good news and I am happy to have at least tried to help.

Given the problem's resolution, that error message is very misleading!

There are script tasks (which run in the Control Flow) and script components (which run within a data flow). It is the latter which I think you would need.

IMO it...

There's no way of doing that just through a quick bit of configuration - looks to me like it will need a script component to read each line and do...

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...

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...

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...

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.

Koen Verbeeck (2/10/2011)

The name is indeed, quite dead. I decided it was time to grow up and lose the nickname I invented...

- Da-Zero is dead! 🙂

That is not a question!

Are you trying to access data from a linked server?

Use a data conversion transformation in the data flow.