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)

You rated this post out of 5. Change rating

2010-01-12

9,588 reads

I’ll walk through the KDA UI and tackle the first challenge before diving into...

While I mostly write about SQL Server, I have a soft spot for Kusto....

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Comments posted to this topic are about the item Life Moves Pretty Fast

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Comments posted to this topic are about the item 50 Years of Microsoft

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...