"Guestimate" is the keyword.

You could start with determining each columns max data length (/2 for the number of chars)

Then create your trial table and try the import.

Keep in mind to...

someone forgot to update the download xls :blink:

the chaps already helped out 😉

the complex and/or/and/or where clause

The suggested:

WHERE QO01ACCIDENT_YEAR in ('2008','2009','2010')

AND

(QO01SUBMIT_AGENCY_ORI = 'XXXXXXXXX'

OR

QO01MUNICIPALITY = 'XXXX')

provides the same predicates,...

It doesn't accept invalid FK values.

Please post ddl (the actual please) of your involved tables as well as the sqljob giving the error as well as the actual error...

Certainly there has been something wrong with a foreign key value for the inserted batch.

I would query the source table using a where not exists correlated query using the foreign...

Stefan Krzywicki (4/20/2011)

---

CirquedeSQLeil (4/20/2011)

---

GilaMonster (4/20/2011)

---

LutzM (4/20/2011)

---

Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the...

it should be col1 + col2

Ninja's_RGR'us (4/20/2011)

---

Nothing blunt in there... just solid experience. I don't...

Another thread requesting the same options:

http://www.sqlservercentral.com/Forums/Topic1096149-391-1.aspx

Ninja's_RGR'us (4/20/2011)

---

ALZDBA (4/20/2011)

---

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance...

GilaMonster (4/20/2011)

---

Ok, I'm going to be blunt (and probably unpopular)

I have seen this happen before. App on a weak server moved to a nice powerful monster, and performance promptly degraded...

Edward-445599 (4/20/2011)

---

ALZDBA (4/20/2011)

---

AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance...

:w00t::w00t::w00t::w00t::w00t::-D:-D:-D:-D

How's that for a dyping error 😉

another msdtc resource: http://blogs.msdn.com/b/asiatech/archive/2009/11/18/how-to-configure-msdtc-resource-for-windows-2008-failover-cluster.aspx

Keep in mind , if these new addresses are not addressable from the current addresses (vlan/ranges) this needs to be an all in one operation or your cluster may become...