I was able to complete this.

Yes I just created a sp as an example.

If I keep views, I would need to put the DB1_QA   and   DB1_TEST onto a separate SQL Server.  Yes only 1 new...

I added a few alerts, I am not able to find one alert for when auto growth occurs.  Would you know what number event this is?

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645611(v%3dsql.105)

Thank you I shall look at the alert steps now.

I was able to see the MINSIZE and this was 67 GIG and the intital size of the database was 200 GIG so the shrink went to the min size.

I...

Great example, thank you.

Thank you SSCGrur

Mr SSCertifiable,
Wow, I can actually set up the Alert and do this so I get it alerted in the SQL Logs for all my...

Give the account Sysadmin rights aswell.

Within the source there is a connection manager with a variable value which is the select statement that has select cast as varchar etc...
The select statement runs on SQL...

Package -> OLE DB destination editor has mapping one to one ,  properties is fastloadmaxInsert of 2147483647 access mode openrowset using fast load.

It is taking data from one data source on one SQL server to another and just within the SSIS package does a mapping only and into another table.
Nothing complex...

I can't get this to run, it only does one database only not all...

Thank you

Great details, I got back 1 TB of space by changing to CCI indexes.  Eventually I will use it up with database growth.
Shrinking is not a good idea as...

Wow thanks for the information.

I strongly advice against using DBCC SHRINKFILE in this way, it's much better to add data files/file groups and shuffle the objects around to...