Browse by Tags

SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues

Published 9 April 8 2:22 AM | SSQA.net

Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime...

Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer

What are advantages of 64-bit system in relation to SQL Server?

Published 19 December 7 8:40 AM | SSQA.net

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has...

Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies

FIX: An access violation may occur intermittently when you run an Integration Services package that contains a Data Flow task in SQL Server 2005

Published 24 September 7 1:49 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, package, ssis, kba, 2005, access violation, data flow, integration services, task

Cumulative Update 3 for SQL Server 2005 Service Pack 2 - watch this space

Published 10 August 7 8:8 AM | SSQA.net

Yet another information on cumulative update for SQL Server 2005 Service Pack 2 installations and make are note of the following: This cumulative update package will be released in August 2007. The information that is presented here is subject to change...

Filed under: sql server, package, update, sp2, 2005, cumulative