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,773 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,773 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
1,305 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)
19,957 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
5 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,947 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
6 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
440 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,693 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
169 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
Comments posted to this topic are about the item Multiple Display Productivity
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers