SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Developing SSIS Packages


Developing SSIS Packages

Author
Message
SQL_Enthusiast
SQL_Enthusiast
SSC-Addicted
SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)SSC-Addicted (480 reputation)

Group: General Forum Members
Points: 480 Visits: 422
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!
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6172 Visits: 14456
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
Lowell
Lowell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28054 Visits: 39926
BIDS is a trimmed down version of VS2010 with the project templates related to Business Intelligence installed.

i have VS 2010 professional, and I have SQL 2008 standard installed on my machine; when i open Normal Visual Studio, i can create a new project, and select the right template; you should be able to do the same.
AFAIK, it doesn't matter which order they are installed (VS2010, then BIDS, or vice versa), because the templates are installed in a common location.



Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

tmitchelar
tmitchelar
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 508
BIDS is all you need! Install it and go to town.
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6172 Visits: 14456
tmitchelar (3/28/2013)
BIDS is all you need! Install it and go to town.


The VS2010 Premium comes with more BI development templates than BIDS, I am running the Ultimate edition which includes Tabular projects.

Kind regards,
Gift Peddie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search