I had the same issue and here is how I resolved it. Try to run dbcc checkdb but it was taking forever to run and there is no...

enterprise edition and the site is

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

been asked in the interview.

Got it…. All I had to do was go to the package property and in the debugging option set run64bit run time to false ---- thanks for the hit

Use OLE DB Source ( and put ur select statement in there) then have an excel destination . Then in the control flow- have a send mail task that follows...