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)
13,048 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,786 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,996 reads
Blogs
Adding a Check Constraint to a Table–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Azure SQL Database Elasticity – Presentation Notes
By DataOnWheels
This blog covers the content and points to the code used to create the...
How To: Create Schema Only Database Copies
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Forums
Joining 2 select results into a single row
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...
Ask SSC