Pitso,

You should be able to do it just fine using Parameters in SSRS, unless something changed in 2008 that I don't know about. I believe you make the value as...

Riiiggght. Quite a DUH moment for me here.

Bulk Insert Task doesn't work if the table has more or less columns than the file has.

To make it work, I had to...

Grateful to both of you for helping out. Thanks!

It was causing all sorts of errors for me, though. Too many to count. I was trying all sorts of variations on the expression.

LEN() was the magic bullet. I ended...

Chris Morris-439714 (10/20/2010)

---

Good Lord Tom, I'd always crossed Lanzarote right off my potential places to visit list because of the British tourism. Your account paints it in a completely new...

Now see, I've tried the ISNULL(effDt) without the == TRUE and while it didn't "bleed", it did error out on me. But then again, I haven't tried the entire line...

Just an FYI: This...

But if you aren't on the same server, does SSIS always skip past the Source and go straight to the Destination during Debug?

Or am I just seeing strange behavior?

Steve,

I don't think IF...THEN...ELSE works in SSIS. That's why I'm trying to use the ? : conditional. And it's not evaluating correctly...

I'm trying to format an 8 character string into...

I'm a little brain-dead this morning. LZ?

Foresight

Bill_CCAC (10/19/2010)

---

Hi All. I'm hoping for ideas on how to make either my query more efficient of a better way of collecting the same result set. This query currently takes...

There was a museum downtown in the basement of one of the downtown office buildings, many moons ago. Which one is that?

John Rowan (10/19/2010)

---

Isn't Durham downtown?

There's one on 10th or 13th... (10th, I think) when you're heading out of downtown and towards Bellevue. It actually...

I'm not really good with the scripting code, but I have an alternate suggestion. 2, actually.

Pull the data into a temp table with an identity field and then use that...