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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(16)

You rated this post out of 5. Change rating

2010-01-12

9,655 reads

I haven’t posted in a while (well, not here at least since I’ve been...

One of the things that I like about the SQL Server docs (MS Learn...

For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...

is there a no code way to limit an ssis extract from excel to...

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

hi we have to replace talend which generally was used to move files. talend's...

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers