We are planning to migrate from 2005 to 2012 and we have so many ssis packages but we dont have the project files for those packages. Developers creates SSIS packages but during prod deployment we only ask them to give .dtsx file and we put that file on server in C drive and our sql agent jobs points to those packages. Thats how we use it for more than 100 packages so we dont have any project files.
1. I want to migrate all these packages all at once to 2012. Is this possible and recommended?
2. Here they says u have to open project file in SSDT and I dont have that file.
Can I create project on 2005 and put all these packages under 1 project? And if I do it that way will it work or any issues?
And If I dont want to create project then what is the easiest method for me to upgrade packages?