Found this great article which got my issue resolved.

Set the ftp task to use Passive mode !

http://vnu10.blogspot.in/2011/11/problems-in-ssis-ftp-task.html

I resolved this by setting the Memory to 61440 in the SQL server where my reportserver is hosted.

By default when SQL server is installed, the Max memory is set to...

No , I dont need any code on how to export. The system is built to use SSRS to export excel and changing the code is not in scope.

It seems...

Hi,

This is the code

System.Diagnostics.Process objProcess = new System.Diagnostics.Process();

objProcess.StartInfo.FileName = "abc.rdl";

...

This is resolved. Below was the issue.

My c# proj had references of other c# proj's which had MangedDTS dll referenced in them. I first rebuilt them , added there references...

Integration Services are installed and is running.

Ok, there's nothing at database level that we can set to force the temp tables to take precedence of current DB collation?.

Yes we can, our SQL team created it now. Issue resolved.

Hi,

Any feedback/pointers anyone?

No, it's the app pool service account on which our asp.net application runs, not the sql server.

This service account has access to the DB's and our asp.net authentication is set...

Thanks Chris, I will check and build my query based on this , will provide you the results. Thank you

Hi,

Unfortunately I do not have the execution plans handy , so I am not able to share it.

Client says , the language setting has bee changed , as per us it has not , so need some kind of proof that it has not been changed.

Bret,

Thanks ,...

Thanks, so is there a log somewhere stored of when the Server settings was changed.

83 views , but no replies....