Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,948 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Space Sensitivity in SSIS Lookups
It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...
2009-09-29
2,736 reads
[Off Topic] Workstation Upgrade
It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest...
2009-09-26
547 reads
More Free Training Resources
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-25
1,907 reads
Creating Dynamic Outputs in SSIS
In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.
2009-09-24
13,179 reads
It's The Job
Today we have a guest editorial from Tim Mitchell that looks at the stereotypical geek. Have you worked with one? Is it harder to manage technical people? Or is it the job? Read Tim's thoughts and let us know if you agree.
2009-09-24
153 reads
Skipping Items in a Foreach Loop
Recently, my friend Jack Corbett asked a question on Twitter:
In a nutshell, the SSIS foreach loop will enumerate a given...
2009-09-23
3,475 reads
More Free Training Resources
A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...
2009-09-21
1,245 reads
Getting Into the Biz, Part 3
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
2009-09-21
1,239 reads
The Netbook: Upgrade to Windows 7
I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...
2009-09-19
597 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers