A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager failed a memory allocation call for 20485670 bytes...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications FIX: The LogReader agent unexpectedly consumes all CPU resources when the agent handles a failed connection in a SQL Server 2008 transactional...

Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: Connector 1.0 for SAP BI throws an exception when data is being loaded in parallel in a SSIS 2008 package http://support.microsoft.com/kb/975058/en-US FIX: The check phase of the...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: <action name>" error message http://support.microsoft...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in...

There is much more sayings on the blogs about 64 bit platform issues when you have 32 bit applications, so it bit noise to create there about the common problem that I have seen (virtually anywhere) that SSIS packages will suffer a lot between these platform differences, such as when you got to run a...