Very clearly laid out. Thanks. My query is that I have sql server 2012 edition with sql server data tools (2010 edition). I have managed to make a ssis catalogue that can be seen in ssms. However my package project doesnt have a deploy option. Does it mean that deploy option is only available with sql server data tools 2012?

Thanks