October 2008 - Posts

ETL in the cloud, or just for the cloud?
Published 27 October 8 2:48 PM | dougbert
Lots of comments today about PDC and the Microsoft executives discussing Windows Azure, the new platform for cloud computing. "Everyone" - that is, Matthew Roche and Jamie Thomson - noticed (without even being present!) the "ETL" on...
Filed under: ,
Didn't make it to the recent Microsoft BI Conference?
Published 21 October 8 4:33 PM | dougbert
Well, you saved a ton of money, but missed a lot of fascinating presentations. Each hour brought another panicked decision over which talk to choose, from the several available tracks. (Except when Donald Farmer's title promised to make me "cool...
Filed under:
MSDN publishes first 2 articles by Integration Services product vendors
Published 21 October 8 4:14 PM | dougbert
MSDN/TechNet has just published 2 new articles by third-party vendors of commercial products that work with, or complement, SQL Server Integration Services. In Extending Integration Services with the Script Task and Script Task Plus , Ivan Peev of CozyRoc...
Filed under: , , ,
Connectors now available for SAP BI, Oracle, and Teradata
Published 21 October 8 4:3 PM | dougbert
Both of the promised post-RTM packages of connectors for use with SQL Server 2008 Enterprise and Developer are now available for download, since last Friday's release of the October Feature Pack that contains the SAP BI connector. Each set consists...
Filed under: , , , , ,
New 10-minute how-to videos on Integration Services
Published 16 October 8 11:30 AM | dougbert
The Integration Services documentation team at Microsoft recently published its very first batch of 10-minute how-to videos. We hope that beginning to intermediate users will find these useful, and we're pleased to be taking some first steps beyond...
Filed under: , ,
Setting an expression dynamically
Published 11 October 8 4:53 PM | dougbert
Former Integration Services developer Michael Entin recently responded to an interesting question on the internal SSIS discussion list at Microsoft. The user was asking: How can I assign the expression [in this case, for the Derived Column transformation...
Filed under:
The first Integration Services 2008 book is now available
Published 9 October 8 3:53 PM | dougbert
http://www.amazon.com/gp/product/0470247959/ Professional Microsoft SQL Server 2008 Integration Services by SQL Server MVPs Brian Knight and Erik Veerman, our own broadly smiling Grant Dickinson, and industry experts Douglas Hinson and Darren Herbold...
Filed under: ,