Have you tried using a derived column with the correct target data type as opposed to casting it in the SQL statement?

You've got a couple solutions to look at. One, use the SCD transformation to do the compares for you. You'll still need to configure the updates types in...

Is there any sort of date column in the source table that could show you which rows have been updated? If you could do something to avoid comparing the...

Sure it does. On the advanced tab, where I'm sure you modified...

I'd be a full time parent, no questions asked.

Our corporate support team plans the DR strategies for our servers. We will be...

Thanks for the info. I've read through them and it sounds very interested. We'll consider this.

Anyone else??

Paul brings up an interesting point in that the business key from the file would not normally be the PK in the table. This whole thing may not happen...

I don't want to ask a dumb question Steve, but Fusion SSDs? Can you elaborate a bit on this, have you put this to use anywhere? What kind...

Just bumping my thread.....

So the moral of the story is that out of 15 years of SQL Server expreience, a query index hint was chosen as the solution 2 times! Just think...

I, too, have only had to use an index hint one time. At my last company, we had a stored procedure that accepted about 16 parameters and performed a...

From BOL:

WITH (

Specifies that the query optimizer use an optimization or locking strategy with this table and for this statement. For more information, see Table Hint (Transact-SQL).

In SQL Server...

Are you using the Merant driver for Progress? If so, Merant is a third party vendor right? Contact them instead of Progress. By the way, the Progress...

Ha! I was actually quite suprised that no one snuck a post in by the time I finished typing my response.