February 2009 - Posts

Import EBCDIC in SSIS packages with updated Lysine 1.1

Published 20 February 9 7:40 AM | dougbert

You can now import EBCDIC data more reliably in SQL Server Integration Services packages with version 1.1 of "Lysine", just announced by Patrick & Ben at Amino Software . If you work with EBCDIC dta, what's in it for you? "The major...

Filed under: ebcdic, third-party products, vendors

Exporting data from SSIS to Excel 2007: Gotchas

Published 13 February 9 2:49 PM | dougbert

The default Microsoft Excel 2007 file fomat, with the file extension .xslx , is in fact an XML file, or rather a Zip file that contains multiple XML files. However you can also save an Excel file in binary format, with the file extension .xlsb . For more...

Filed under: known issues, Excel, Import and Export Wizard

Not happy with a Books Online topic? Rewrite it yourself!

Published 11 February 9 2:5 PM | dougbert

OK, you can't do this directly . But you can do the next best thing! Use the Community Content feature in the MSDN Library to add more information, examples, clarifications, or corrections for all to see. Let's take a look at this Integration...

Filed under: msdn, BOL

Add helpful package design tools to BIDS: A Codeplex project focus

Published 10 February 9 10:20 AM | dougbert

Among the gems on found on Codeplex , "Microsoft's open source project hosting web site", BIDS Helper stands tall. BIDS Helper is "a Visual Studio.Net add-in with features that extend and enhance the functionality of Business Intelligence...

Filed under: Codeplex, samples, tools

Just Published: The Data Loading Performance Guide

Published 9 February 9 9:37 AM | dougbert

Read the new white paper on optimizing bulk inserts from the SQLCAT team: The Data Loading Performance Guide Be prepared for technical depth, including hardware and networking optimizations!

Filed under: performance, articles