Hi. Great article. Thanks. Can i ask if changing the isolation level of the DB TO READ_COMMITTED_SNAPSHOT would have prevented the deadlock?

S

Have you looked at the data source timeout settings of the report. You wont see this anywhere else except in Visual studio designer or Report Builder

Hi, I dont this is possible and it wouldnt make sense either. I have dealt with SSRS 2005 upgrades recently to 2008 R2 and the schema is different. I think...

Yep SQL Profiler will be your best bet. Under the trace template you can filter by the login name and see what that specific user is executing.

Hi,

Its worth trying to run Profiler against the one which is working and then against the one which is not. Ensure that the credentials are getting passed across correctly....

Hi,

You can use Visual studio(VS) for different reasons. Firstly you can use a SSIS project within VS to import data from within the excel spreadsheet. then you can further...

Is this a live production database. If so, dont use a Trigger as this could have potential performance problems. Have you thought about using SSIS?

There are many ways...

Hi,

Sure. Please find enclosed

Hi,

Please take a look at my output. I may not be able to get in contact shortly. But i will endeavour to further help in the next few...

Ok just looking at this now. Is there any reason you do the conversion. Sorry it might be obvious but im trying to help

Ok fair point

Ok it is definately something to do with the conversion. Can you confirm what the data type is of the tabel you are writing to?

I meant at the end of the package flow So

step 1 Data flow task

a) it retrieves the excel file

b) it writes to the destination (sql table)

step 2 Execute SQL...

Or alternatively what you could do is have a execute sql task after the insert into your table with a "DELETE FROM TABLENAME WHERE ROWSNOTWANTED=''