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
598 reads
Todd McDermid's Blog
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,771 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
1 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)
18,409 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
5 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,051 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
184 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)
7,909 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
96 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,688 reads
Blogs
Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Forums
how to remove duplicate rows in sysobjvalues
Hi, Can you advise how to remove Duplicated rows in sysobjvalues. or remove the...
Few questions about cloud computing course
Hi I'm currently doing a networks management degree level 7. I'm in the final...
Interview question to test beginner SQL competency?
Hello, I need to help my boss come up with a simple-ish SQL quiz....
Ask SSC