Post reply

Getting error while creating new project for SSIS

  • July 12, 2013 at 2:52 am

    #395127

    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

  • July 12, 2013 at 2:58 am

    #1631851

    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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 12, 2013 at 5:10 am

    #1631879

    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

  • July 12, 2013 at 5:11 am

    #1631880

    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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 12, 2013 at 5:15 am

    #1631881

    can you please let me know which version should I use? i.e Enterprise or Developer

  • July 12, 2013 at 5:28 am

    #1631885

    Developer. (doesn't really matter for functionality, but developer tends to be a tad cheaper)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 12, 2013 at 5:30 am

    #1631886

    Thanks Koen 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply