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!