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,309 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,970 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
442 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
170 reads
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
My blog has been quiet lately. I recently wrapped up a master’s program (more...
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
We've been testing out Azure SQL Managed Instance and created SSIS packages to run...
Greetings, I need to transform data returned in a query from several tables as...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers