Paul_Harvey (4/20/2010)

---

Thanks for the advice.

Can I just ask....

If I set this constraint, does it potentially prevent the entire package from running, or will components AFTER the one I wish to...

Expanding on that a little ... You could use an Execute SQL task to run something like

Select Count(PK) from table where ...

and map the result directly to a variable, which...

... and there was me thinking that I never won anything 🙂

See here.

ct_man12 (4/17/2010)

---

Thanks Phil. I tried doing the SET ANSI_NULLS OFF, but it didn't work. I read about it, and in my query I am not doing any comparison where a...

There is a better way of doing this which does not require a lookup table.

Add a derived column which converts NULLs to "No_Product_Line" and leaves non-NULL data as is, something...

Maybe this link will help you.

da-zero (4/16/2010)

---

Ha, of course you're right.

I divised my suggestion from the template that I always use. This template has a conditional split to sort out the insert and the updates....

da-zero (4/16/2010)

---

I think you can just use an OLE DB Source to read the data....

OK Rookie, I'll go easy on you 🙂

If a matching record is found (based on ID), do you just want to ignore it? Or perform some sort of update?

We need a bit more info ...

What exactly do you mean by import? Do you have matching PKs? What happens if a match is found - update or ignore? Should...

da-zero (4/15/2010)

---

Two hours today that is 🙂

(I don't count the hours constructing the package,...

da-zero (4/15/2010)

---

<rant>

I just wasted 2 hours on Excel in SSIS, so I can definitely tell you what the disadvantages are 🙂

---

And don't get me started on the automatic conversion of...

Max worksheet size is 1,048,576 rows by 16,384 columns in Excel 2007.

The fact that there is no explicit column data-typing in Excel is the single biggest cause of problems in...

Easiest thing to do is post some sample data. Your description is not detailed enough.