SSIS Catalog Automatic Log Cleanup
Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time....
2019-01-01 (first published: 2018-12-19)
2,371 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Why I’m Breaking Up with Facebook
I have been in a serious relationship for more than 12 years. My partner in this relationship has brought me joy through the years, but lately, I feel like...
2019-01-01
6 reads
A Better Way to Clean Up the SSIS Catalog Database
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables....
2018-12-30
325 reads
A Better Way to Clean Up the SSIS Catalog Database
Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables. This nightly process removes data for operations that are...
2018-12-30
6 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest...
2018-12-20
212 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest sushi restaurant. The exterior could be described as tasteful...
2018-12-20
3 reads
SSIS Catalog Automatic Log Cleanup
Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time. In this post, I’ll show you how to set...
2018-12-19
54 reads
SSIS Catalog Execution Parameter Values
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they...
2018-12-18
324 reads
SSIS Catalog Execution Parameter Values
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they deploy those packages to the SSIS catalog. Using the...
2018-12-18
6 reads
Processing Multiple Files in SSIS with the Foreach Loop
Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly...
2018-12-17
180 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers