• SQL_Enthusiast (3/27/2013)


    I'm tired of typing this question into Google and getting 1,389,456 wrong answers. So I thought to myself, "Why don't you ask the experts?" So I'm here. I only have SSMS 2008 installed on my machine. I need to start developing SSIS packages. I know I need Visual Studio, but what version?

    I have Visual Studio 2010 Premium installed on my machine, but it doesn't have the capability to build SSIS packages. I know SQL Server installation media has Business Intelligence Development Studio on it, is that the only Visual Studio "version" that works for SSIS development?

    Thank you in advance!

    The short answer is no but to use VS2010 you need SQL Server 2012 for the package development and yes you can use VS2010 premium for BI development. And it is also better to use SQL Server Developer edition, that is the Enterprise edition with deployment restrictions. The reason is you have access to all the features you can use.

    Kind regards,
    Gift Peddie