Everything sounds fine.

Notwithstanding your comments, I think the next step should still be a check on permissions. Please try putting the file in

c:\import

(or wherever)

and see whether you still get the...

How are you passing the file names to the job? Is it hard-coded, or via some sort of config?

What is the full UNC path + file name?

Yeah right. You accidentally used the word 'dump' in both the title and text of your original post.

But glad you...

bpowers (6/20/2011)

---

Each quarter we receive a spreadsheet containing data that is used to update a column in a table. We usually just concatenate the fields within the spreadsheet to build...

Great input. Makes my post only 50% correct & taught me something in the process, thanks.

GSquared (6/20/2011)

---

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and...

Not at all - feel free to post back with findings/issues.

robinrai3 (6/20/2011)

---

hi All,

Just need a steer on this ..what is best way to do this or has somebody out there already done it

i was thinking of calling a sp that...

JustMarie (6/17/2011)

---

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and...

drew.allen (6/17/2011)

---

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and...

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second nature and as AS has...

Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get the SSIS functionality to...

Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).

Brandie Tarvin (6/16/2011)

---

Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS...