I was thinking something similar and it might just be a better solution then using SQL aliasing. Because you can execute a script at the end of the subscription...

I was able to track down the cause of the replication job disappearing. The development team was dropping and recreating the database from a previous backup that did not...

I would also take any ideas on how to automatically retry a child package in the event of a failure as an alternative workaround. Because really, this issue sounds...

Whoops. Thanks for the other suggestion as well. It might be very handy in a future project. Always learning new tricks Thanks!

Instead of using a Derived Column Expression I used a CASE Statement after the Data load.

UPDATE DimTable

SET [rank] = CASE

WHEN [lv] BETWEEN 1 and 19 THEN 1

WHEN [lv] BETWEEN 20...

Lynn Pettis (8/23/2011)

---

I have seen a maintenance task not delete an old backup file that had been restored to a server after it had been deleted previously by the maintenance...

NJ-DBA (8/23/2011)

---

are the files you are testing with actual database backup files?

can you test on a local drive as opposed to network share?

Is the volume compressed?

The successful completion...

Chuck Hottle (8/23/2011)

---

I recall looking into this once and there is a check subfolders ” check box that wasn’t checked in the clean-up task. That would only apply if...

Thanks all for the suggestions.

However, I question if it will work as I just tried to run the

EXECUTE master.dbo.xp_delete_file 0,N'\\cifshare\sqlBackup\Servername_folder\databasename_folder\',N'bak'

Nothing was touched even after I ran the execute...

I tried adding a "\" at the end of the Path but that did not work either. I seem to remember trying that at some point. I also...