The connection type "FILE" specified for connection manageris not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
Then I tried creating a new SSIS package and right clicked to add a new connection manager and I got the error
The new connection manager could not be created
I tried installing SQL Server 2005 SP2 and it solved the issue