Could you please post your table structure and some sample data so we could verify the advice we're giving you before we give it? It's hard to help you when...

There are several ways to split strings in addition to the method Chris mentioned. Google "SQL Server Split Strings," choose one that seems to work, and apply that methodology to...

chris.stuart (10/21/2010)

---

When you select the table to be populated in the drop down list in the OLE Destination component, you have the "Name of the table or the view:", you...

Boys,...

irobertson (10/20/2010)

---

Hi Bill,

One thing you might like to try is to pre-calculate the two correlated subqueries that you're using to generate criteria and hold the values in variables.

Also,...

I'd still like the OP to answer. Assumptions about this sort of thing are dangerous.

I'm a little confused. What exactly are you trying to map?

Are you just trying to show the "guts" of a SSIS package? Or is this something else?

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?