Best way to upgrade 400 SSIS packages from 2008 to 2012?

Question

Post reply

Best way to upgrade 400 SSIS packages from 2008 to 2012?

keymoo

SSCrazy

Points: 2975
More actions
December 8, 2015 at 8:09 am

#303146

Is there an automated way this can be done?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 1

keymoo (12/8/2015)
Is there an automated way this can be done?

Are the packages stored in msdb or filestore?

keymoo SSCrazy Points: 2975 More actions · Answer 2

curious_sqldba (12/8/2015)Are the packages stored in msdb or filestore?

FileStore. They're all in a single directory and are run using C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe. Each package has a package configuration file that sets the runtime variables.

have2much SSChasing Mays Points: 640 More actions · Answer 3

http://www.sqlservercentral.com/blogs/dknight/2012/05/16/upgrading-packages-to-ssis-2012/

keymoo SSCrazy Points: 2975 More actions · Answer 4

have2much (12/8/2015)
http://www.sqlservercentral.com/blogs/dknight/2012/05/16/upgrading-packages-to-ssis-2012/

Thanks but that requires manually adding each of the 400 packages to a Project first. I'm looking for something automated.