I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform, specially within ETL processes completion. So at first, when you install SQL Server 2005 and select both Integration Services and Business Intelligence Development Studio, as this it to ensure to have both 32 & 64 bit type of components installed...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/x64/archive/2007/11/19/2797.aspx