Talking about me again. I'm both "pretty" (in a very masculine way) and "clever". 😛

jasona.work (11/18/2015)

---

Phil Parkin (11/18/2015)

---

Jack Corbett (11/18/2015)

---

Remember, it is not about winning or losing because everyone is a winner if they try their best :rolleyes:. Keeping score will...

Phil Parkin (11/18/2015)

---

Jack Corbett (11/18/2015)

---

Remember, it is not about winning or losing because everyone is a winner if they try their best :rolleyes:. Keeping score will just...

Have you tried running a trace or XEvents session (assuming the destination is SQL Server) to see if the update statement is being run and what is actually being executed...

I can't seem to duplicate the problem.

Can you attach the SSIS package?

I have attached the file I used to try to duplicate the issue. I had to upload it...

scorpman (11/18/2015)

---

Hi,

I have a question, in terms of performance what's best in a query with LEFT JOIN:

- Put the clause in ON of the LEFT JOIN

- Put the clause in...

What are you getting for errors on the OLEDB Command?

Can you post table definitions and the update statement?

jasona.work (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Brandie Tarvin (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm not sure...

Steve,

Please send the sun east, but keep the snow.

You don't need a regex to find out if it is an integer in .NET. You can use INT32.TryParse().

Never tried this, but try creating a SYNONYM for the function in the same database as the table and then reference the synonym in the constraint.

etirem (11/13/2015)

---

Absolutely not. It is for more than 200 M records and I need that to work in SSIS but struggling to get it.

In SQL, I'm using a function...

Is Linesheet a directory or part of the image name that is the same for every image? If it is a directory then I think your issue is that...

Do you want numeric values or integer values (whole numbers)? Based on the images you shared you want only integers.

Do you want to do it in SQL or SSIS?

If...

Apparently the source_code column in the source table contains NULL values which means you'd never match and also be an insert. You just need to exclude nulls from your...