CirquedeSQLeil (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

Great question, thanks.

I could deduce the correct answer since I ran the query on my development machine.

Not all results were zero and the columns aren't nullable, so...

What are you using to bulk insert the data.

One solution (and there will probably be more) is the following:

use SSIS with a .NET script task (or just build a .net...

I don't know who told you, but ACE also doesn't work on 64 bit.

http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/58c4c61e-fa86-4809-bf7d-21bacb055d3e/

(sorry I ruined your day :-))

edit: apparently there is a 64-bit release for office 2010:

http://www.microsoft.com/downloads/en/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

GSquared (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

GSquared (3/2/2011)

---

Actually, to partially refute my own assertion, I was once told why I wasn't hired. It was because "I was too strong a candidate". ...

Jeff Moden (3/2/2011)

---

If the expected format of the source data is always the same, this is a simple way to do it...

DECLARE @SplitString VARCHAR(100)

SELECT @SplitString = 'bas-06-12586'

SELECT Col1...

Corrected that mistake...

GSquared (3/2/2011)

---

Actually, to partially refute my own assertion, I was once told why I wasn't hired. It was because "I was too strong a candidate". The recruiter wasn't...

One of the...

You can download an Oracle connector for SSIS here:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d9cb21fe-32e9-4d34-a381-6f9231d84f1e&displaylang=en

When I've started out with SSIS, I've read the following book:

http://www.amazon.com/Professional-Microsoft-Integration-Services-Programmer/dp/0470247959/ref=sr_1_1?ie=UTF8&qid=1299070341&sr=8-1

It may be a bit dry and technical, but it contains almost everything you need to know about SSIS. For...

If the conflict with transactions through the DTC still persists, you can try to create your own transactions by placing an Execute SQL Task with BEGIN TRAN at the beginning...

Great question, thanks.

I could deduce the correct answer since I ran the query on my development machine.

Not all results were zero and the columns aren't nullable, so there were two...

Craig Farrell (3/1/2011)

---

There's another option, and it's in stream without a VB component, but does require some repetitive coding and usage of expressions. You'd have to used the derived...

SanDroid (3/1/2011)

---

It can mean a lot of things,...

Great, then you should have absolutely no problem with a technical interview...