CODEWITHSUNDEEP
sqlsql-serverdeploymentssis
Agustin Zanini
Agustin Zanini

Reputation: 65

How can I deploy/import/install an SSIS project in SQL Server 2012 (Integration Services) without using the "Deploy" option im SQL Data Server Tools?

I have a working SSIS project locally done by me with SQL Server Data Tools. I found out that the easiest way to have the project deployed in SQL Server is using the option "deploy", available on that IDE. I have done it successfully locally.

My problem is that I am not able to deploy the project directly to the client Server beacuse I have been ordered to give him no more than files, scripts , etc. in order to get the project deployed only by him. He cannot instal SQL Server Data Tools and deploy. I wonder if I can export my already deployed project in my local SQL Server instance and make him to import it?

Upvotes: 1

Views: 1292

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31775

You can give him the .ispac file from your SSDT project's /bin folder, and he will be able to import it to the SQL Server using SSMS.

Upvotes: 1

Related Questions