Reading Excel into SSIS via OpenXML Scripting
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've...
2012-08-02 (first published: 2012-07-31)
4,797 reads
Reading Excel into SSIS via OpenXML Scripting
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've discussed before. They boil down to one main reason:...
2012-07-31
1,736 reads
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to...
2012-05-23 (first published: 2012-05-22)
21,051 reads
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might...
2012-05-22
26 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
8,000 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult...
2012-05-14
1,073 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult to have a package run properly when it can't...
2012-05-14
24 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL...
2012-05-08
640 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel...
2012-04-12 (first published: 2012-04-09)
2,715 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel files. If a spreadsheet has macros in it, you...
2012-04-09
215 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers