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

8,639 reads

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

I sometimes get asked from customers if they should use a star schema or...

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

I am trying to get data from myslq into mssql with ssis. I am...

how to check which job or stored procedure using xp_cmdshell in sql server ?

i need to configure job to consolidate sql error log sizes from multiple servers...

Visit the forum

See possible answers