How to run SSIS Project as a SQL Job
In this piece by Pilip Horan, learn how to create an SSIS catalog and run a project as a SQL Agent Job.
2017-01-06 (first published: 2015-05-11)
15,473 reads
Philip Horan
Automate Your Backup and Restore Tasks
A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.
2015-12-16 (first published: 2010-10-05)
16,094 reads
How to FTP a Dynamically Named Flat File
Learn how you can dynamically name a file in SSIS and then send it using the FTP task.
2015-05-04
8,969 reads
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Getting Started with DDL statements of Cassandra Query Language
Comments posted to this topic are about the item Getting Started with DDL statements...
Ask SSC