Still confused. One, the formatting doesn't allow me to easily see what is in what column. Also, Are we updating existing data? Your original post really did...

Three years experience, asking questions like this? More like 1 month of experience over 36 months.

RBarryYoung (4/14/2009)

---

Manie Verster (4/14/2009)

---

...

RJ, I hope you don't mind but I'm going to jump in here. Barry, maybe RJ's requirements is small enough to justify a distribution list but every...

GilaMonster (4/14/2009)

---

I saw it. I had a half-written, very snarky reply that I deided was better not posted....

Okay, try this instead:

create table dbo.xtable (

ID int,

val1 varchar(30) null,

val2 varchar(30) null

);

create table #tmp (

...

Okay, I...

Gail, see the latest on this one you were just on?

The user (cdi_js)...

Would this work, or are there already values in x_table that you also have to take into account?

--ID val_1 val_2

--1 25 26

--1 42 31

--2 55 25

--3 60 30

--

--

--Second table has...

You are running it, it is running as a part of...

bruce.trimpop (4/14/2009)

---

Matt Whitfield (4/14/2009)

---

bruce.trimpop (4/14/2009)

---

Unfortunately, the "readily consumable format" is a problem. Packaging something up that would cover all or most of the critical functional variations would be a bit...

Heather McPherson (4/14/2009)

---

Hi, I am very new to SQL an when I paste the example into Query analyzer

I get the following error

Server: Msg 208, Level 16, State 1, Line 6

Invalid...

RBarryYoung (4/14/2009)

---

Lynn Pettis (4/14/2009)

---

There are several of us who would take on the challenge of attempting to rewrite a cursor based solution as a set based solution. If you...

I'm at a loss. When I was looking at Raw files, I didn't encounter this problem. I didn't go that route at the time anyway as I was...

With that, are you using a Raw File Source in the next package?