Generally, splitting your data across as many read and write heads as possible will help performance.

You have to examine your hardware first though.

Remember RAID 5 causes an XOR operation when...

A database snapshot would be my first response as well, but you have not given enough information for us to help.

What do you intend to use the copy of the...

If your view is "SELECT * FROM MyTable" there is no performance difference using a view vs a table. The optimization engine will still continue to use indexes regardless...

We outsource a lot of development to a consulting company. Over time, we have had to firm up a lot of "rules" because without them we get garbage. ...

The report being run is in the URL so it can be caught in IIS logging.

The smoothest approach I can think of now would be to add a web service...

During the pre-execute phase, objects cache information that they can. So, if you just have an OLEDB Source and a OLEDB Destination in your package the pre-execute is probably...

From a quick test, there seems to be no performance difference (as I suspected). I use named queries in the DSV for everything, even if I need the entire...

The File System Task is pretty simple to use. I am sure there are some detailed instructions if you search the web on how to copy a file using...

I looked through my old projects and came across the first one in which I had similar behavior. Unfortunately, my suggestion will not work for your situation.

My problem was...

I have seen this before.

The ExecuteSQL task sees things happening in order.

You probably have the ResultSet property set to "None". So, SSIS executes the package and assumes it is...

I never said anything about being a hack or a cheat as being a bad thing.

And I freely admit that I don't always make the best use of my time.

Thanks...

Ok, call me a hack, but I have to do this a lot and I cheat.

In a new column on the spreadsheet, enter a formula like this:

="UPDATE MyTable SET MyValue='"...

Except for the whole "customizing by customer" (fight that with every ounce of energy you have - you will lose and end up doing it anyway, but fight it) I...

You can either add a SQL Command task to your control flow that deletes the data in the spreadsheet (just run a DELETE command like you would against any other...

You need the correct security in SSRS (making yourself an administrator will suffice for now). You also must be running the Enterprise Edition of Reporting Services.