CODEWITHSUNDEEP
sql-servervisual-studiossisetlsql-server-data-tools
psbookmark
psbookmark

Reputation: 115

How to create a ssis project

I want to use ssis to transfer database. I installed sql server 2017 developer version. After installation, I could not found SQL Server Data Tools under the SQL Server 2017. Then I installed the SSDT for my visual studio 2017. I could not found the Integration Services Project in the File -> New -> Project.

Maybe when I installed the VS, I didn't pick Business Intelligence as the default setting.

So how can I create a SSIS and make a ETL package? I don't mind do it through VS or SQL server.

Upvotes: 2

Views: 888

Answers (1)

AswinRajaram
AswinRajaram

Reputation: 1622

Open SQL Server Data Tools > New > Project. Then in New Project box, choose Business Intelligence from the Templates. There you can see the Integration Services Project. Select it and create the project.

Upvotes: 3

Related Questions