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...

GSquared (3/1/2011)

---

If you interview, and think you did well, and get rejected, you are never, ever told why. There are litigation-prevention reasons for that (as commented about earlier here),...

vick12 (3/1/2011)

---

Thanks a lot for your reply. I am thinking of using "Analysis Service processing" task in SSIS 2008 to process analysis services 2000 cubes. But I am getting a...