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
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
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
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,408 reads
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
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
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
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
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
183 reads
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
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
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers