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.
2010-01-12
8,639 reads
By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.
2010-01-12
8,639 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
DBAs are being asked to know everything for 6 figures which cap out for...
Comments posted to this topic are about the item Common Table Expression Misunderstandings
I have a DAG between On prem and Azure. We have a maintenance window...