Those additional spaces seem to have been collapsed/removed somehow.

Are you questioning the results of the following?

if 'Diane Watson' = 'Diane Watson'

select 'Matched'

else

select 'No...

That's pretty much...

Actual rows and Est rows are very different. Are your statistics up to date?

We really need to see the DDL for the table and its indexes.

Also, can you explain what you mean by this:

..which results on half the table for first part of...

Perhaps you can run some SQL after the transfer to set the job statuses?

Vertigo44 (3/23/2015)

---

My Source connection was set to look for 5 columns with the last column delimiter expecting a CR/LF. However, our vendor continues to add additional columns to the flat...

Snargables (3/23/2015)

---

I'm sure i could multiply it by something to get it to work however that doesnt explain why it will convert 1.35e6, 1.35e5, 1.35e4, 1.35e3, 1.35e2, 1.35e1, 1.35e-1, 1.35e-2,...

Try these

select cast( '1.550e-6' as float) * 100000

select '1.550e-6' *...

It is converting from varchar to float.

I'm not sure why it is displayed in exponential notation, but it is still a float and appears to have the right value.

If you use decimal instead, I think that...

Snargables (3/23/2015)

---

For whatever reason i'm unable to cast anything more thtan e-4 to a float which makes no sence. Am i missing something?

select cast( '1.550e-6' as float)

?????????

returns 1.55E-06

????????

select cast( '1.550e-5'...

Eric M Russell (3/23/2015)

---

If DATE_MODIFIED is populated when the row is initially inserted, and it's updated consistently by the application, and it's indexed, then that's...

Lowell (3/23/2015)

---

or is there an incremental primary key in the Oracle source that you can just select fromOracle where the...

Is there a 'DateCreated' column in your source data?

If you type

Me.Connections.

does Intellisense give you any options at all?