Post reply

Run a SSIS package on a server with only workgroup edtioin innstalled

  • April 15, 2009 at 7:24 am

    #202075

    I am really a newby to SSIS, so this question might be naive...

    I have developed a SSIS package on my dev server, that I want to run on the production server. But on the production server we have only the SQL server Workgroup edition installed, -will I be able to run the SSIS package on the production server? If so, -how?

    I've tried using the dtexec, but I got this error:

    "The SQL Server Execute Package Utility requires Integration Services to be insta

    lled by one of these editions of SQL Server 2008: Standard, Enterprise, Develope

    r, or Evaluation. To install Integration Services, run SQL Server Setup and sele

    ct Integration Services."

    I will be really grateful for any respond!

  • April 15, 2009 at 8:26 am

    #978116

    Let explain your error what it is saying is you have the SSIS runtime in Work Group edition but you are using features that is only supported in the Standard, Developer, Enterprise and Eval the last three are the same Enterprise edition. So I think in Work Group edition you cannot use any ETL feature so check below for SQL Server 2008 features compare.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Kind regards,
    Gift Peddie

  • April 16, 2009 at 12:36 am

    #978627

    Thanks for your respons, I will let them know we have to upgrade our SQL server version!

Viewing 3 posts - 1 through 3 (of 3 total)

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