Embedding the Execute As Login in an Exec command worked. I am not sure what the difference is but in that it is not longer broke I am not going...

I have decided to use a SQL solution as it does not require any software to be installed on user workstations. I have setup two SQL users. User1 is in...

I'm using 2008 r2 but I figured it out. The path I was given wasn't quit right. Sorry for bothering you

I have experimented with certificates and took a quick look at Power Shell and SSIS and I think SSIS is probably my best options. I found an artical on using...

Thank you. I will experiment with each of the options you have suggested.

Chuck

My background is a good bit of SQL scripting mostly self taught and enough vb scripting to get me by. I am willing to learn anything that will help processes...

I gave up and put SSRS on the same box as SQL. This is the third time I've had a problem with the linking them up after something changed. It's...

Hi Anthony,

Both links indicated that the site was off line.

SSRS and IIS are on the same box. I did this not because it was necisary but because I needed to...

Yes

Here is the code:

bulk insert #t2 from '\\efs2\e$\WebFiles\Uploads\boaMother.csv' with(firstrow=5,fieldterminator=',',rowterminator='

Is bulk insert considered Ad Hoc?

Chuck

The permission are the same as they were before the upgrade to R2. Domain users have read execute and domain administrators have full control.

Chuck

I'm using bulk insert. The exact error is:

Cannot bulk load because the file "<<file.csv>>" could not be opened. Operating system error code 5(Access is denied.).

The domain user executing the script...

I opened the project in visual studio, created a new connection and assigned the connection to the query. I can run the report in visual studio with either the old...

Hi Chandan,

The logfile pretty much shows the same thing as the web page plus a bunch of stuff I don't understand. I'll copy it here in case it makes any...

Good morning Chandan,

Thanks for your reply. I checked the SQL server log and there are not entries at the time of the error. I also check the SSRS log and...