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,716 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,654 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,993 reads
Blogs
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just...
My T-SQL Tuesday #129 Time Capsule
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
Azure Database Administrator
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Forums
Send me an email if this job run longer than 30 minutes
Hi I have a job that I need to be notified/emailed if it runs...
Time out expired on the application side
Hi I have an application that is timing out i run the query...
Ask SSC