We never saw the actual query though.

It is possible that you filter those rows out somewhere (with a join or something like that).

However in some cases the query optimizer might...

The character at the end of the line. You know, the one you get when you hit "enter" on your keyboard.

Can you share the bulk insert command you used?

De groeten terug 😉

Do you have any carriage returns/line feeds in the file where they don't belong?

UPDATE a

SET omschrijving= SP.[omschrijving]

,verkoopprijs= SP.[verkoopprijs]

,gewijzigd= getDate()

FROM artikelen a

LEFT OUTER JOIN [Hofstede].[dbo].[sparepartsupdate] SP

ON a.PartNrFabrikant = SP.PartNrFabrikant

WHERE (AR.omschrijving != SP.omschrijving) OR (AR.verkoopprijs != SP.verkoopprijs);

Here you go:

UPDATE artikelen

SET omschrijving = [Hofstede].[dbo].[sparepartsupdate].[omschrijving] ,

verkoopprijs = [Hofstede].[dbo].[sparepartsupdate].[verkoopprijs] ,

gewijzigd = getDate()

WHERE(PartNrFabrikant in(

SELECT ar.PartNrFabrikant -- only 1 column here

FROM artikelen AR

LEFT OUTER JOIN [Hofstede].[dbo].[sparepartsupdate] SP

ON AR.omschrijving !=...

GilaMonster (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

Yes, you assign the result of the expression...

The first 3 errors are there because those columns might be present in multiple tables, and SQL Server doesn't know from which table to take it.

The last error is because...

Yes, you assign the result of the expression to a column....

Now I'm curious what went wrong of course...

Or you could set the datatype in SSIS to DT_NTEXT and save you all the trouble in VB.NET.

I prefer the alias with the equal sign. It is very easy to align everything, especially when you have larger expressions.

If you add something to NULL, the result is NULL. Then the ISNULL fuction will replace this with 0. So the output is what one would expect considering the formulas...

Dtutil can only be used for deploying packages in the package deployment model.

It cannot be used for the project deployment model (which uses the SSIS catalog).

greg.bull (6/5/2014)

---

Yes, well good idea - but I've trimmed just in case, and displayed the string with [] around it, just to be sure that's not the problem.

I've tried to...