Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 5:51 AM
Points: 419, Visits: 143
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 15,396, Visits: 13,123
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 SQLKover.

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

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 5:51 AM
Points: 419, Visits: 143
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 15,396, Visits: 13,123
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 SQLKover.

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

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 5:51 AM
Points: 419, Visits: 143
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 15,396, Visits: 13,123
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 SQLKover.

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

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 5:51 AM
Points: 419, Visits: 143
Thanks Koen :)
Post #1472949
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse