Excellent advice! Thanks Jeff!

Great article, thanks for posting!

I use a DateTimeStamp column on most of my tables too, usually just to know when a record was entered for problem solving purposes and sometimes...

ho ho ho!! 🙂 excellent solution!

brilliant! thanks so much andras!! much appreciated.

sorry i don't get your question...

however, does the service account have access to the folders/ftp your trying to aceess?

does anyone else have any advice on this?

which user is being used to execute the JOB?

STEPS->Run as:

-Make sure you can execute the package from Visual studio (I'm sure you have)

-Make sure the account you're using to schedule the job has permissions on the folders etc the...

Thanks Paul,

I suspected as much. Anyway, I've used your excellent post to do what I needed and you've probably saved me many hours of trawling through t'internet to find...

Paul,

Thank you very much for posting that example!

It works a treat!

Is there anyway of doing away with the Schema.Ini file and specifying the rules (ie tab delimited and line feed...

Ryan, Jason... thanks for the replies!! Genius!

Ryan, I've tried yours and it works a treat (so far:-)

Jason, I'll give yours a bash tomorrow... it's late and it's hometime.

one more thing (yeah, like colombo)

whilst what i've done works (for me), i'm guessing it's not the best approach, so any recommendations/guidelines appreciated.

Ta

Okay, I've solved it.  Here's what I did:

A1. Go to Services in Administrative tools.

A2. Open "SQL Server (MSSQLSERVER)"

A3. On the "Log On" tab, check the "This account" radio...

The SQL Server Agent Service is running under "Local System", however when I change this to "Network Service" I get the following in the Logs:

Message

Login failed for user 'NT AUTHORITY\NETWORK...

Just to ask the same question in a different (more leading) way, how can i create a windows user on SQL server and use that user to execute the Job? ...

Hi,

How do I find this info?