ssis licensing question

Evan Brown 21 Reputation points
2022-04-12T10:34:29.237+00:00

I have a quick question about SSIS licensing. I would like to set up a process for a user to run locally on their workstation that will run an SSIS package on their workstation that will in turn pull data from a server that is running a licensed sql enterprise instance. Is there any licensing requirements needed on the local workstation to do this?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,996 Reputation points
    2022-04-13T01:26:49.017+00:00

    Hi @Evan Brown ,

    In a production environment, SSIS must run on a properly licensed SQL Server (Enterprise Edition). Whether that is the source server, destination server, or a dedicated ETL server depends upon your needs (and budget).

    For detailed information about the license issue, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,726 Reputation points
    2022-04-12T12:15:14.85+00:00

    HI @Evan Brown ,

    SSIS run-time requires MS SQL Server license. That's why it is usually runs on a dedicated server.

    I would like to set up a process for a user to run locally on their workstation that will run an SSIS package on their workstation...

    That's why your idea is very questionable.

    0 comments No comments