Just a suggestion, if you have both SS 2005 and 2008, check the connection manager you are using for the SQL task to see if you have right instance for...
The sample package that I was interested in is the AWDataWarehouseRefresh, I thought that was the package that would refresh the Adventureworks2008DW database, by extracting data from the Adventureworks2008 database,...
This is certainly useful info for a lot of us who aspire to get this certification. I have only used SQL server for transaction processing, I have used it for...