Another thing to remember, is that declared variables are unless initialized, null.

So, it's common when doing this concat trick to do;

declare @Body varchar(3000)

SET @Body...

Ah, yes, well.. that is true.

It is 'sort of' intended, though.. But it's a side effect.

When figuring out age from a dob date, there's one question that needs answering first.

If...

Dunno about Oracle, but here's a way that works in SQL Server...

-- some data with dob and genders

declare @ages table ( dob char(8) not null, gender char(1) not...

Does the application tell the server which 'path' it's using, or is coming from?

Or is there some other way you can identify that 'path'?

If there is, then that is the...

I figured as much

Unfortunately I don't have a device to try it out on

But it looks...

That's also 'normal' behaviour when loading data. You want to update existing rows, and insert the new ones.

No need for a cursor! Just a single update on all that qualifies,...

Nah, wouldn't have helped. Just found it when I posted about it, and you put me om track about linking it

/Kenneth

Nothing like a good ol' three-finger to solve any problem.

(though, access tokens also gets reset/renewed during a reboot)

Anyway, glad you solved it!

=;o)

/Kenneth

No probs Remi. Done and done. Linked it to here.

=;o)

/Kenneth

Question answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=325083

/Kenneth

Please don't cross-post.

The same question is also posted in the Admin forum...

/Kenneth

Why don't you just try it out?

It seems to be free to use (good thing)

Or don't you have any thoughts on it?

/Kenneth

Looks to me like a permission issue anyway...

Can you verify that the account used when running as a job still has permission to access \\violet\dataimport\test.txt  ?

/Kenneth

...which also is likely to be the most efficient method.

/Kenneth

Yes, there are some help for doing 'admin' starts, presumably used from a command prompt.

start the sqlserver service from a prompt and use some or a combo of the following...