Dougbert on SSIS
SQL Server Integration Services news and tips from Microsoft technical writer Douglas Laudenschlager
June 2008 - Posts
Not for use with the SendMail task!
Published 25 June 8 3:33 PM |
dougbert
Hey, someone finally told those Marketing folks that there's something other than coffee mugs and polo shirts! But I wasn't expecting...US postage stamps! Sure enough, now you can mail your bill payments with a SQL Server 2008 stamp... Click the...
Speaking of writing Office XML...
Published 21 June 8 1:17 PM |
dougbert
In my third installment on Excel issues , I proposed writing out Excel XML rather than binary Excel files as one way to avoid both the issues of the Excel driver, and the risks of Excel automation. Recently I came across a DTS custom task that I wrote...
Excel in Integration Services, Part 3 of 3: Issues and Alternatives
Published 21 June 8 1:5 PM |
dougbert
This post is the 3rd and last in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives Introduction Don't expect miracles...
Where is Excel Part 3?
Published 21 June 8 9:57 AM |
dougbert
Coming later today after proofreading. Please don't anticipate miracles - some of the issues with the Excel driver simply don't have solutions or workarounds that are satisfactory in all cases. You forgot something in one of your blog posts Please...
Profiles, Settings, and More Settings
Published 18 June 8 12:26 PM |
dougbert
MVP Matthew Roche blogged the other day about the joys of discovering some useful but little-known design-time options for Integration Services in the Options dialog box for Visual Studio/Business Intelligence Development Studio. I suspect that many of...
Excel in Integration Services, Part 2 of 3: Tables and Data Types
Published 18 June 8 11:24 AM |
dougbert
This post is the 2nd in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives Tables What's a table in Excel? The source...
Excel in Integration Services, Part 1 of 3: Connections and Components
Published 16 June 8 7:0 AM |
dougbert
This post is the 1st in a series of 3 planned installments about using Excel data files with Microsoft SQL Server Integration Services. Connections and components Tables and data types Issues and alternatives The Excel Driver Excel connectivity in SQL...
New docs on SAP with SQL Server Integration Services
Published 12 June 8 9:16 AM |
dougbert
Integration Services developer Matt Masson has already blogged about the new connectivity components for SAP BW for SQL Server 2008 Integration Services. This set of components will consist of a connection manager, source, and destination. They will be...
Upgrading Custom Components for SQL Server 2008 Integration Services
Published 11 June 8 7:44 AM |
dougbert
The SQL Server 2008 Books Online page in which we describe the steps for upgrading and redistributing custom components is now live: Upgrading Custom Objects for SQL Server 2008 Integration Services This topic is for shops that wrote a custom component...
64-bit Considerations for SQL Server Integration Services
Published 10 June 8 10:31 AM |
dougbert
Herewith my best effort to restate the contents of the Books Online topic, 64-bit Considerations for Integration Services , more simply and cleanly. Unfortunately the BOL topic has become quite messy over time, as one bandage is applied over another,...
Using Integration Services with Microsoft CRM
Published 9 June 8 9:33 AM |
dougbert
I counted 57 posts (not threads) in the SSIS forum on MSDN about using Integration Services with Microsoft CRM. Thanks to SSIS-with-CRM wiz Catherine Eibner from Australia, I discovered that CRM MVP Darren Liu has covered the subject in detail in a blog...
New product: Data Quality Manager from Australia
Published 8 June 8 2:49 PM |
dougbert
Microsoft consultant David Lean from Australia sent us information about a new data quality product from down under named Data Quality Manager . There's a wealth of information about the product on the site. It uses, and integrates with, Integration...
New product: EBCDIC Source component from Amino Software
Published 8 June 8 12:16 PM |
dougbert
Today Ben Harrell of Amino Software announced their new custom Source component, code-named "Lysine" , for importing mainframe EBCDIC data into the data flow of an Integration Services package. The component also includes an EBCDIC connection...
Search
Go
This Blog
Home
Contact
Syndication
RSS for Posts
Atom
Blog Recent Posts
Making SSIS work with the 64-bit Excel (ACE) provider
Restarting SSIS packages after failure
Running multiple SSIS Foreach Loops in parallel
Running PowerShell tasks from an SSIS task
Loading Active Directory data with SSIS
Tags
2008
64-bit
articles
books
cdc
Codeplex
custom components
data profiling task
DTS
ebcdic
Excel
expressions
Import and Export Wizard
known issues
lookup
msdn
mvp
off topic
performance
programming
samples
setup
third-party products
vendors
videos
Archives
September 2010 (1)
August 2010 (6)
June 2010 (5)
May 2010 (1)
April 2010 (4)
March 2010 (1)
February 2010 (1)
January 2010 (2)
November 2009 (7)
September 2009 (3)
August 2009 (2)
April 2009 (8)
March 2009 (6)
February 2009 (5)
January 2009 (6)
December 2008 (3)
November 2008 (6)
October 2008 (7)
September 2008 (2)
August 2008 (3)
July 2008 (3)
June 2008 (13)
May 2008 (13)
April 2008 (2)