I have downloaded the data tools for vs 2017 serveral times and I still can open a project for SSIS. Is this a licensing issue?

Question

I have downloaded the data tools for vs 2017 serveral times and I still can open a project for SSIS. Is this a licensing issue?

Brett Green 1

I think the title says it all but if it isn't licensing then why do the tools not show up. Even clicking on an existing DTSX just brings it up in XML.

Yitzhak Khabinsky 26,586 Reputation points

2021-11-23T23:00:00.813+00:00

@Brett Green ,

You need to open a VS solution *.sln file that contains a reference to the SSIS project.

1 answer

Your answer

Yitzhak Khabinsky 26,586 Reputation points

2021-11-23T23:00:00.813+00:00

@Brett Green ,

You need to open a VS solution *.sln file that contains a reference to the SSIS project.

Answer 1

ZoeHui-MSFT 41,496

Hi @Brett Green ,

Open SSDT, go to Tools--Extensions and updates, check that Integration Services Project is installed and enabled.

To install Integration Services project support in ssdt2017, you may need to run the SSDT standalone installer.

To run a DTSX file, double click will not open it with SSDT, you may need to create a new integration service project in SSDT and then add existing package.

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.

ZoeHui-MSFT 41,496 Reputation points

2021-11-26T06:29:05.047+00:00

Hi @Brett Green ,
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Share via

I have downloaded the data tools for vs 2017 serveral times and I still can open a project for SSIS. Is this a licensing issue?

1 answer

Your answer