If you are storing your packages in MSDB, you could try exporting them to the file system somewhere local on the server and switching the sql agent job to call...

Brandie Tarvin (4/8/2016)

---

I'm beginning to wonder if this is a DNS problem. We have the instances aliased, but we don't currently have DNS records specifically referencing the aliased instance names....

Is the reason you're doing this to solve a performance pressure situation?

Dynamite

Does the job run if you reference 'localhost' instead of the server's name?

Also, what happens if you try to run the individual job steps as the user that the job...

Obfuscation

Then there was a client of mine who won't be named who decided to store the data for all the Widgets in a copy of the Gadgets database.

Seriously, you...

If the behavior of this is not what you expected and you don't need the ability to restore to a point in time, consider using the Simple recovery model instead...

What Gila said. If you do the cost analysis of doing all this extra stuff vs the cost of the enterprise license, you might be pleasantly surprised that the...

Room

It would be worth your while to consider the cost of these alternative solutions vs the enterprise license cost. It might be about the same if you factor in...

Shell

Bikini

How are you with regular expressions? If you are going the clr route, look into .net's regex classes, i think you could find pre-defined patterns on the web for what...

Timid