Yesterday while trying to get OUTPUT parameters to work with SSIS Execute SQL Task I encountered a lot of problems, which I’m sure other people have experienced. BOL Help is very light on this subject, so consider this the lost page in help. The problem comes about because different providers expect parameters to be declared […]
You are browsing archives for
My Issues With SSIS Event Handlers (And Why I’ll Use Them Anyway) Jamie Thomson’s response to the above article Design Issue With SSIS BIDS Package Configuration Wizard SSIS: Be wary of using SourceSafe Enabling SSIS packages in Reporting Services Reports
Jamie’s post touches on one potential problem of having SSIS packages that are too big: errors with Source Safe while checking in. SSIS Packages are saved as xml documents, SourceSafe is going to put in a lot of effort to save the delta changes of the xml between saves. While I haven’t encountered this problem […]
A quick list of things I am / have been reading in the last week. Metadata tool and whitepaper for BI components SQL 2005 Metadata Samples Toolkit and whitepaper now available SQL Server 2005 Business Intelligence Metadata Whitepaper SQL Server 2005 Business Intelligence Metadata Samples Toolkit Indexes: An Overview and Maintenance for Performance Recovery Planning […]
Microsoft has quietly kicked out the final version of SQL Server 2005 and Visual Studio 2005 to MSDN subscribers ahead of the Launch Tour 2005. The .Net 2.0 Framework has also been released, which you will need to install/use either of these great things. If you’ve been keeping track of SQL Server 2005’s development, you’d […]
Let me direct you to an article by Ash on speed differences between two approaches to handing failed lookups in SQL Server Integration Services. Failed lookups are likely to happen at some point, and in most cases you won’t want your package to fail as a result, but rather a default or derived value or […]
While searching through google for performance tips on SSIS / DTS 2005, I came across Ashvini Sharma’s blog. There’s a number of great entries dealing with package execution and ways you can improve your throughput. Checkout the entry on DefaultBufferMaxRows and DefaultBufferSize.