Thanks for the reply.

After I posted my question, In the mean time I tested this scenario, I noticed some difference, when I added individual columns with individual indexes, it showed...

Did you make sure that the path you are specifying in Dev environment and server environment do exist and are same. Also the account from which you run the SSIS...

Right click on the task, click Edit and Advanced Edit. It will give you options that you may use to fix this.

Just FYI... Using BIDS you can design your package...

Did you notice if one of the tasks is taking long time and all tasks are taking long time in Package.

Second, make sure that index-rebuilding is not running at the...

If I have understood your query correctly, you are trying to create multiple backup files for each individual database.

You have to add one backup database task in maintenance plan for...

Grouping_ID is not a sub clause, but a function.

There will be no single opinion on this.

Why don't you use SQL's own backup utility, if encryption is not your concern.

However, I would use Red Gate SQL Backup Utility. After...

It loads the logs from MSDB. You need to make sure that you are able to access msdb database without any issues. Try to run a few queries on MSDB...

I guess this thread has same topic..

http://www.sqlservercentral.com/Forums/Topic412378-146-3.aspx

If you are planning to Attach system databases too (Master, MSDN etc), you may face some issues. Since structure of few system tables in system databases is different than sql...

setlan1983 (9/17/2009)

If a field with...

You need to consider on optimize the query and indexes.

Make sure the maintenance tasks are running regularly as per schedule, like, rebuilding indexes, de-fragmenting etc.

There are inbuilt XML functions to use with XML data and columns. You may find some of the useful functions and how to use it at this location:

http://www.15seconds.com/Issue/050803.htm

You may write your own sproc to fetch the details. If you search on google, you may find out couple of scripts to do the same thing.

I was getting error message something similar to what you see. I noticed that using EXECUTE AS is dishonored when you enable option "be using logins' current security contexxt".

you...