Look in your installation folder, usually C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap in the LOG directory. You will see a file called Summary.txt and a folder for each time you've...

Yes, you can

Again, no problem, but...

You can use sys.sysindexes.

The column rowmodctr contains the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table.

http://technet.microsoft.com/en-us/library/ms190283.aspx

Yes, that's what you need to do

After you...

You should find everything you need here

http://technet.microsoft.com/en-us/library/ms191295.aspx

That part is a bit more tricky. Do the filenames contain a date or do you need to get it from the file attributes?

I would say using a script task...

Depends a bit on how long a period you like to look at. You can use the sys.dm_db_index_operational_stats function and look at the leaf_insert_count column. But since it's a...

I hope I get it right now.

Create your package with two "file system tasks" connect them with an "on success" connection.

Then define a variable "sourcepath" and change the sourceconnection properties....

GilaMonster (9/6/2013)

---

Two places that need to change.

First, the cursor definition

declare FindFragment cursor for

SELECT object_id, name FROM #IndexFrag WHERE (avg_fragmentation_In_Percent > 5) and (avg_fragmentation_In_Percent < 40) and (name not like 'null')

because...

Not sure I understand what you want. Do you want to make then file and\or path configurable? The use SSIS variables.

Or do you need to move the package to another...

Is this really a local drive or maybe a mapped network share?

Change the following line

set @tablename = ( select OBJECT_NAME(object_id) FROM sys.indexes WHERE name = @Result)

To

set @tablename = ( select s.name +'.'+ OBJECT_NAME(o.object_id) FROM sys.objects o

JOIN sys.schemas s

ON o.schema_id =...

Are both defined on just one column?

In that case I would question the design, but there is a possibility that the table was split up into two tables because...

Use the "File System task" from the SSIS toolbox.

As long as your reports don't contain any custom code you can also move all of your reports by moving your report server database to the new server. Technet has...