Dougbert on SSIS : expressions

Wow, an SSIS Expression Tester tool

dougbert — Thu, 10 Jun 2010 20:28:00 GMT

Darren Green of SQLIS .com has posted a new SSIS Expression Tester on Codeplex: http://expressioneditor.codeplex.com/ See the SQLIS blog post from yesterday (6/9/10): http://www.sqlis.com/sqlis/post/ssis-expression-editor-tool.aspx German-language blog...(read more)

Get the new SSIS Expressions cheat sheet from PragmaticWorks

dougbert — Tue, 03 Nov 2009 16:59:00 GMT

Available as both a Web page and a downloadable PDF at http://www.pragmaticworks.com/cheatsheet/ . ...and more! -Doug...(read more)

New book: Learn some SSIS, help children affected by war

dougbert — Tue, 29 Sep 2009 16:04:00 GMT

" SQL Server MVP Deep Dives ," a result of collaboration among 53 SQL Server MVP's and others, is now available for pre-order. The authors are generously donating all their royalties to a charity for children affected by war. Find out more...(read more)

Faking success in SSIS

dougbert — Fri, 28 Aug 2009 20:14:00 GMT

A SQL Server Integration Services package has a set of properties with similar names that let you: force the result of running the package return a custom value from the package Their similar names make it easy to confuse these properties. To make matters...(read more)

Setting an expression dynamically

dougbert — Sat, 11 Oct 2008 23:53:00 GMT

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...(read more)

Expressionable data flow component properties in Katmai

dougbert — Thu, 01 May 2008 17:20:00 GMT

To supplement the current version of the list that's here in BOL, here are some additions or corrections to the list of custom properties of data flow components whose values can be set by using an expression in SQL Server 2008 "Katmai":

ADO Source (formerly DataReader Source)

SqlCommand
TableOrViewName

ADO Destination

BatchSize
CommandTimeout
TableOrViewName

Lookup Transformation

SqlCommand (the SELECT statement that you optionally enter on the Connection page)
SqlCommandParam (the parameterized SELECT statement shown on the Advanced page)

SQL Server Destination

BulkInsertTableName
BulkInsertFirstRow
BulkInsertLastRow
BulkInsertOrder
Timeout

As in SQL Server 2005 Integration Services, you set these properties in the UI on the containing Data Flow task, and not directly on the individual component.

-Doug