Anyone ..any idea?

I have to store the PDF in azure DB, which will be extracted from .NET code as pdf again. Going with the Azure blob approach is an overhead for me,...

Guys, Any ideas?

Thanks much. You cleared my big question.

Now, Users table also has users who are no longer in the system and maybe even removed from SQL. So, when i take...

Thanks. I will try out the options.

Is it because of Excel 2003. If I point it to Excel 2010/2013, would it be resolved?

Also, is it possible to find which value is causing the issue. I tried...

To confirm, Encryption (using master certificate) is only for protecting/securing the data, but it does not obfuscate it i.e, changing the values from AAA to BBB.

Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than what we had...

Source is SQL 2005 DB

Destination: Excel 2003

Excel not installd in server. I am thinking about installing excel in server, which might resolve driver related issues.

I will also re-check and reconfirm...

ERROR is same for all these failures.

IN CMD, I use DTSRUN /S SERVERNAME / E /N DTSNAME

The same query is also used in job. CMD is executing from my ID...

Any ideas why i can run DTS as a scheduled task (from Windows command) but not from job.

Job was running for long time without any problem. Now only, i starteed...

To further add, the DTS when run from Windows batch/command file runs fine. ONly when the dts is run from Job (using DTSRun), it fails with the error.

Before the DTS/JOb runs, I am copying an empty excel template and then running the DTS. Data never gets more than 100 rows.

SQL Agent id has full access to folder/excel/share...

Can we change in Catalog table? Is ther no other way other than modifying all the 200 reports?

1. Do I have to move ReportServerTempDB too?

2. Apart from moving ReportDB's, any other way to migrate Reports?