Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

↑

sql server,integration services - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » sql server » integration services (RSS)
01 February 2010 15:58

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

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; ...more from here;
Posted by ssqa.net | with no comments
Filed under: , , , , , , ,
11 February 2009 14:15

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,
07 March 2008 13:44

Data Warehouse Scalability Features in SQL Server 2008

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , , , , , , , , , , ,