Dougbert.com
Microsoft SQL Server Integration Services and more by Douglas Laudenschlager.
Sign in
|
Join
|
Help
Home
Blogs
Media
March 2009 - Dougbert on SSIS
Dougbert on SSIS
Home
Contact
Go directly to . . .
DOUGBERT'S BLOG
SSIS blogs list
SSIS downloads
DTS downloads
Miscellaneous downloads
Blog Search Form
Go
Syndication
RSS for Posts
Atom
Tags
2008
64-bit
articles
books
cdc
Codeplex
custom components
data profiling task
DTS
Excel
expressions
known issues
lookup
msdn
mvp
off topic
performance
PowerShell
programming
samples
setup
spatial
third-party products
vendors
videos
View more
Dougbert Visitors
Archives
January 2012 (1)
April 2011 (1)
January 2011 (1)
December 2010 (2)
November 2010 (3)
October 2010 (1)
September 2010 (4)
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)
Sort by:
Most Recent
|
Most Viewed
|
Most Commented
Import from a macro-enabled Excel 2007 workbook (*.xlsm) (CORRECTED)
CORRECTED ON 4/2/09 FROM ORIGINAL POSTING ON 3/31/09 The Office 12 ACE Provider recognizes the .XLSM extension for a macro-enabled Excel 2007 workbook. However, the Excel Connection Manager (in SQL Server 2008 Integration Services) only recognizes the...
Published
Tue, Mar 31 2009 12:35 PM
by
dougbert
Filed under:
Excel
Get looped, with your own custom Foreach Enumerator for SSIS
The lack of control flow structures such as looping was one of the main shortcomings of Data Transformation Services (DTS). If you're nostalgic, just look at the scripting hoops that you had to jump through to loop, by disabling and re-enabling steps...
Published
Fri, Mar 27 2009 1:35 PM
by
dougbert
Filed under:
programming
,
custom components
Find the top Knowledge Base articles for DTS
Here are the top Microsoft Support Knowledge Base articles that SQL Server Data Transformation Services (DTS) customers have been reading. You may find them useful also. This time I've simply sorted the list from most viewed to least view, for the...
Published
Tue, Mar 17 2009 3:26 PM
by
dougbert
Filed under:
DTS
,
known issues
Find the top Knowledge Base articles for SSIS
Here are the top Microsoft Support Knowledge Base articles that Integration Services customers have been reading. You may find them useful also. The numeric columns in the following table represent rank in the indicated period by number of page views...
Published
Tue, Mar 17 2009 9:45 AM
by
dougbert
Filed under:
known issues
Solve some common pain points in BIDS
Here are a few suggestions for some of the things that may be tripping you up while you're working on SQL Server Integration Services packages in Business Intelligence Development Studio (BIDS). Thanks to my buddy Jason Howell, who's an SSIS whiz...
Published
Mon, Mar 16 2009 3:46 PM
by
dougbert
Filed under:
known issues
,
BIDS
Debug your packages in 32-bit or 64-bit mode
At run time, you decide the "bitness" of Integration Services package execution on a 64-bit computer by running the 32-bit or the 64-bit version of the dtexec.exe command prompt utility. At design time in Business Intelligence Development Studio...
Published
Mon, Mar 16 2009 12:28 PM
by
dougbert
Filed under:
64-bit
,
BIDS