I am in the process of migrating a SQL server 2005 to a SQL server 2012. On the 2005 server, SSIS packages are used to upload CSV data into various databases. These SSIS packages are created in Visual studio 2005.
My questions are around the versions of software I require on the new server:
1. Will the new SQL 2012 server require an install of visual studio? if so, which version? It would only be used for SSIS development - would an express version be suitable?
2. Are there any migrating tools to help?