Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Katmai   (RSS)

SQL 2008 & VS 2008

Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don't try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 - now that Visual Studio 2008 is released - what are the plans for BIDS and support of BI projects VS 2008?
Posted by michen | 5 Comments
Filed under: ,

SQL 2008 November CTP is available

Get it from https://connect.microsoft.com/SQLServer One of the improvements in this build is the ability to persist Lookup reference data and use non-OLEDB sources for Lookup.
Posted by michen | 0 Comments
Filed under: ,

Custom transforms: determining end of rowset

It appears like a EndOfRowset property of SSIS buffer is being often used incorrectly, which could cause problems when you move the code to SQL 2008. Unfortunately, some Microsoft docs helped to spead this error, so let me clarify what it means and how it should be used.
Posted by michen | 3 Comments
Filed under: ,

SSIS Backpressure Mechanism

One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge local
Posted by michen | 0 Comments
Filed under: , ,

Katmai SSIS data flow task improvements

With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release...
Posted by michen | 4 Comments
Filed under: , ,
 
Page view tracker