I was just going to go where Matt took you. To explain what Matt is saying, you should replace your Derived Column with a script component. If I...

I think you will need to create a package variable that you increment in order to do this as SSIS processes row by row not by the set. This...

I agree with Grant with the addition that DRI is one of the main purposes of an RDBMS system so it should do the job at least as efficiently as...

Thanks for the nice words. I found this interesting because I had...

ntaylor (5/22/2008)

---

If consistency was considered more important...

Jeff Moden (5/21/2008)

---

...

I saw one article by a fellow recently. He...

Can you post an example of a working select?

DBA (5/21/2008)

---

so say I have this in my table

'ComputerAA1'

and someone tries to insert this

'ComputerAA1SPACE' --they will get a duplicate error for the constraint

but if they try to insert...

No. From BOL:

Tabs, etc... are not...

My fault on the empty set. In the Object_ID function you need to schema qualify the table and then...

Okay that is good. It means your database was setup to be case insensitive, now we need to know if for some reason your productname column was created with...

DBA (5/21/2008)

---

SELECT len as Length, p.productnumber,p.productID_PK AS ID

FROM Products P

WHERE p.Active = '0'

(p.productname)...

GSquared (5/21/2008)

---

The quick answer is update the table using RTrim.

update dbo.Table

set Column = rtrim(Column)

Since you're using Varchar data type, that will probably do it.

If it doesn't, the thing to do...

Can you post an example like noted in the article referenced in my signature? If you are using equality operators you should find the matching products. There may be...

Backing up across the network is not a recommended practice. If this is necessary you need to grant access to the share to the user executing the backup. If you...