tooba111 (4/3/2015)

---

Set the TypeGuessRows registry setting for the ACE OLE DB provider to 0. It will scan more rows to determine the data type.

Also, make 100% sure IMEX=1 is included...

Eirikur Eiriksson (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

SqlSanctum (4/3/2015)

---

No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've...

SqlSanctum (4/3/2015)

---

No, it was never rescinded after Vatican II, almost everyone thinks it was though. Even my mother didn't believe me when I told her. I've had confirmation from multiple...

SQLRNNR (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

sqlmaverick (4/2/2015)

---

Hi all,

I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I...

Sean Lange (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Grant Fritchey (4/3/2015)

---

Sean Lange (4/3/2015)

---

I found it a rather...

Grant Fritchey (4/3/2015)

---

Sean Lange (4/3/2015)

---

I found it a rather fitting response to somebody who clearly...

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it...

Sioban Krzywicki (4/3/2015)

---

Koen Verbeeck (4/3/2015)

---

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation"...

A little uncool is my middle name. 😎

Eirikur Eiriksson (4/3/2015)

---

sqlmaverick (4/2/2015)

---

Hi all,

I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any...

Eirikur Eiriksson (4/3/2015)

---

Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make...

Set the TypeGuessRows registry setting for the ACE OLE DB provider to 0. It will scan more rows to determine the data type.

Also, make 100% sure IMEX=1 is included in...

It's Friday and I'm grumpy...

http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx

You don't have 10 minutes patience?

I'll give my reply within 10 minutes...

Take a look at Pivot.