Viewing 15 posts - 9,976 through 9,990 (of 11,678 total)
CirquedeSQLeil (3/2/2011)
Koen Verbeeck (3/2/2011)
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...
March 2, 2011 at 11:49 am
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...
March 2, 2011 at 7:15 am
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:
March 2, 2011 at 7:08 am
GSquared (3/2/2011)
Koen Verbeeck (3/2/2011)
GSquared (3/2/2011)
March 2, 2011 at 7:06 am
Jeff Moden (3/2/2011)
DECLARE @SplitString VARCHAR(100)
SELECT @SplitString = 'bas-06-12586'
SELECT Col1...
March 2, 2011 at 7:04 am
HowardW (3/2/2011)
Koen Verbeeck (3/2/2011)
I would be a lot less uglier if the derived column wasn't a one-line-editor.Don't be hard on yourself, I'm sure you're not that ugly 😛
Corrected that mistake...
March 2, 2011 at 6:48 am
GSquared (3/2/2011)
March 2, 2011 at 6:44 am
You can download an Oracle connector for SSIS here:
March 2, 2011 at 5:58 am
When I've started out with SSIS, I've read the following book:
It may be a bit dry and technical, but it contains almost everything you need to know about SSIS. For...
March 2, 2011 at 5:55 am
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...
March 2, 2011 at 3:36 am
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...
March 2, 2011 at 1:53 am
Craig Farrell (3/1/2011)
March 2, 2011 at 12:20 am
SanDroid (3/1/2011)
Toreador (3/1/2011)
or more accurately
8 = 2 (mod 6)
Tell me what the "=" is and we will use wet noodles for the beating. :w00t:
It can mean a lot of things,...
March 2, 2011 at 12:17 am
Joshi-400802 (3/1/2011)
Hi, Koen VerbeeckYes I do have experience in SSIS, I am using SSIS since last 3+ years.
Thanks
Great, then you should have absolutely no problem with a technical interview...
March 2, 2011 at 12:08 am
Viewing 15 posts - 9,976 through 9,990 (of 11,678 total)