Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Getting error while creating new project for SSIS Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 2:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:03 AM
Points: 91, Visits: 57
Hi All

I am getting following error when creating new SSIS package, i have installed SQL server 2008 R2

To design Integration Services packages in Business Intelligence Development Studio, Integration Services has to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.

can anyone please help me on this? Let me know which version should I use to develop SSIS package?

Thanks in advance.

Nikhil
Post #1472907
Posted Friday, July 12, 2013 2:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,553, Visits: 10,429
You don't need SQL Server itself installed on your pc to develop SSIS packages.
However, the error itself states the solution:

To install Integration Services, run SQL Server Setup and select Integration Services.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472910
Posted Friday, July 12, 2013 5:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:03 AM
Points: 91, Visits: 57
Hi Koen

Thanks for the reply,

Yes, I followed the same steps but every time I got the same error. I am using windows 7 , is it something like there problem with windows 7 for SSIS or am I doing something wrong?

If you can provide me the steps or any useful link from where I can get all the details would really help me.

Thanks again for all your help. :)

Regards,
Nikhil
Post #1472941
Posted Friday, July 12, 2013 5:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,553, Visits: 10,429
Windows 7 has no problem with SQL Server or SSIS. My previous laptop had Windows 7 and I made a whole bunch of packages without an issue.

You need to run the SQL Server set-up and in the feature selection pane you need to select at least BIDS and Integration Services.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472942
Posted Friday, July 12, 2013 5:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:03 AM
Points: 91, Visits: 57
can you please let me know which version should I use? i.e Enterprise or Developer
Post #1472944
Posted Friday, July 12, 2013 5:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,553, Visits: 10,429
Developer. (doesn't really matter for functionality, but developer tends to be a tad cheaper)



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1472948
Posted Friday, July 12, 2013 5:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:03 AM
Points: 91, Visits: 57
Thanks Koen :)
Post #1472949
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse