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)
12,386 reads
Philip Horan
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
7,511 reads
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.
2013-09-20 (first published: 2010-10-05)
15,992 reads
Blogs
Azure Platform Series: How to setup Azure Cloud Shell
By HamishWatson
This blog post will be a series on the Azure Platform and some things...
Daily Coping 5 June 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown...
Forums
Attach and Detach Method vs SQL Manage object method
Hi there, if you want to detach a database you would right click on...
How to generating Excel File with multi sheet by using SQL server 2012?
I need to create stored procedure or query or any thing on SQL server...
performance tuning for a subquery
Hey Guys I have a quick questions regarding a better way to write a...
Ask SSC