Jnrstevej (6/21/2011)

---

Thanks for your replies

To be honest i don't understand the script below, this returns 32 for me.

declare @name varchar(256)

set @name = ' 1231'

select ascii(SUBSTRING(@name , 1 , 1))

I...

aaa-322853 (6/21/2011)

---

Ok listen to this. If I set up a proxy account a link it to the SQL Server agent domain account it works?? Something is not quite right when...

Adding to that, trim removes spaces, so the characters to the left that you wish to remove must be something else. Step 1 is to find out what those characters...

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...