Thanks Elliot, trying this out now and will report back 🙂

Lynn, consider the following list of rows (obviously this is far removed from the real data which is 1,000,000+ rows;

price,...

ColdCoffee (8/3/2012)

---

dji (8/3/2012)

---

I want to sum the vol (volume) grouped by price and country. BUT I want to exclude the top nn% and bottom nn% from the sum (this is...

I am facing the same issue.

Presumably you guys found a solution to the problem? If so, any advice appreciated.

I read on another forum a solution which means messing with the...

Jeff Moden (8/19/2011)

---

Heh... just about anything is faster than that. Why...

Jeff Moden (8/18/2011)

---

Understood and...

Apologies, Jeff!

I was most definitely referring to my solution of trying to squeeze the out dated OPENROWSET into the 64 bit environment when mentioning band-aid 🙂

I know I am raking up an old thread by replying, it is entirely deliberate for a couple of reasons.

1) A collective thank you to all those that helped, especially...

Many thanks for the swift reply. I was trying to run a four minute mile before I could walk I guess!

The conditional split is perfect, just what I needed.

The execution was successful

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

-...

Thanks for the post, opc.three.

In a nutshell, win64 and sql 2008r2 was a baptism of fire. At fairly short notice I was required to work at my (sort of) bosses...

Hmmm, that's a point. Maybe when I go into excel to extract the records as per the abc.csv for this thread and my most recent bigger sample of 100,000 rows,...

Thanks for the reply.

I have just done a test and extracted the first 100,000 records from the file that I am trying to bulk insert. Works fine:-D Indicates something lower...

quoted wrong post..

Still cannot get Bulk insert working, this is what I am now ending up with, following the above text to the letter:

Msg 4866, Level 16, State 8, Line...

Guys, you are all brilliant:-D

If only I had posted on here sooner I would have saved myself a lot of pain.

Just been trying the SSIS development in visual studio (never...

Thanks for the further replies.

The SSIS method would require learning a whole new language by the sounds of things? My only experience with SSIS is through the wizard which offers...