Wednesday, November 16, 2011

SQL Server 2012 Editions

›
Microsoft has changed SQL Server licensing for the SQL Server 2012 release to better align with how customers are deploying applications a...
Tuesday, November 15, 2011

The Excel Connection Manager is not supported in the 64-bit version of SSIS

›
When attempting to execute a package that makes use of an Excel Connection Manager you may be presented with the following errors. SSIS ...

Overwrite Excel File in SSIS: Workaround for Excel Connection Manager

›
I recently needed to create a process that would ultimately create an Excel file for import into another system. The other system was built ...
2 comments:
Monday, October 31, 2011

SQL Server Default Backup Location

›
SQL Server makes it easy to set a server's default data and log locations. In SQL Server Management Studio, simply right click on the ...
Friday, October 21, 2011

The Future of Visual Studio Database Projects

›
It is with great sadness that I relay the decision by Microsoft to do away with the Visual Studio Database Project type that I love so much....
Wednesday, October 12, 2011

SSIS Configuration File (.dtsconfig) Behavior (relative path issue)

›
Let me start by saying that I prefer SQL Server configurations over all other configuration types in SSIS for the majority of configurable v...
4 comments:
Monday, September 12, 2011

OLE DB Destination or SQL Server Destination

›
SSIS offers a number of Data Flow destination components. When working with SQL Server databases as a destination there are two obvious choi...