I run such packages with Oracle connections without problems. If you run it from SSIS store make sure you specified protection level when you upload package to SSIS.

You need to...

You can check Reporting Services logs for additional information. Log files path example is: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

One of the clients sent me backup file once with .dat extention. I just restored it as regular backup. This may not be your case though.

What kind of maintenance plans are you running? Are there optimization tasks (reindexing) or backups only? Also, could you check the maintenance plan history? There could be more information if...

You wouldn't see blank columns at all, there will not be gap. Report will have some space on the right.

Another option is to use expression for the columns headings and...

Hi,

I usually set the same alerts initially on all of the servers:

- for all errors with severity 19 and higher

- database log file 90% or more full (have job running...

Do you try to login from remote computer or you run SQL Management studio from the server itself? Shared memory only would work if you login from the server itself....

Check in SQL Management Studio if you have remote connections enabled on the server you try to connect to:

- server properties->connections->Allow remote connection to this server

Also you may need to...

Is it data only or log file? Check the data file and log file sizes on disk. Sometimes log file growth rate is high when it has not been backed...

1) You will need to transfer logins between SQL 2000 and SQL 2005 (http://support.microsoft.com/kb/246133/). If the same logins already exist on SQL 2005 go to next step

2) Backup...

You can try "hidden" property of the column (under Visibility). Design your report layout so it has all of the columns. Then, based on you stored procedure output set hidden...

Yes, it is possible by using the "Web Service task", but I found it quite difficult to configure in my case (I was testing remote web service, don't remember other...

If permissions are fine and synonym is not an option you may need to check schema name (to check if it's part of the table name). So, in report's...

I used once SQL Express on one of the web servers with low database activity. We had just a couple of export/import tasks, the rest were select statements. Usually it's...

Hi Chris,

I use similar "master package". I think I can help you, but I need more information.

Do you use your "master package" (with passwords) as "parent" package? What value do...