Jason Rowland

Run SSIS packages from remote client with stored procedure

By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.63 (16)

2010-01-12

9,014 reads

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Back in December 2019, I started presenting my session on mental health with lots...

Comments posted to this topic are about the item Review Early and Often

I have been trying to find SQL that shows what SQL Agent jobs failed...

I accidentally ran this on a dev server which has locked my acct and...