SSMS via Windows 2008 Terminal Services

Buck Woody has an interesting post about Windows 2008 Terminal services and SQL SSMS. He includes setup instructions and a list of pros and cons. It’s cool to see this functionality making its way into SQL Server. Great job SQL Server Team! The more I tinker with SQL Server 2008, the less it looks like …
Continue reading SSMS via Windows 2008 Terminal Services

SSIS 2008 To Include Silverlight In Next CTP

An unnamed source at Microsoft confirms today SSIS 2008 will integrate Silverlight in the next CTP: The SSIS Debugger with it’s stationary tasks and transformations, just sitting there changing color – where’s the graphic feedback in that? The new functionality will reportedly include more “real-world feedback” graphics. For instance, when a Data Flow task fails for …
Continue reading SSIS 2008 To Include Silverlight In Next CTP

When All Else Fails, SSIS Scripting to the Rescue

Background  I’m working on an SSIS package that FTPs files from heterogeneous sources to Windows servers. I currently have three types of servers in the mix: Windows, Unix, and iSeries. When I first started this phase of the project, I tested the SSIS FTP Task and it worked well… on two out of three.  Durnit. …
Continue reading When All Else Fails, SSIS Scripting to the Rescue