Tuesday 17 September 2013

SSIS Package Deployment



Step 1:
          Right click on the solution in solution explorer and click properties.In the left pane of Property window click Deployment Utility and in right pane set CreateDeploymentUtility property to True and click OK.



















Step 2:

Right click on Solution in solution explorer and click Build.






















Step 3:

Go to the Package path and then go to \bin\deployment folder.Double click the Integration Services Deployment Manifest file.















Step 4:
There are two types of Deployment File system deployment and Sql Server Deployment.As Sql server deployment is safe we can go with this.click next.Now specify the target machine server name and credentials and click browse and select the path.click next.























Step 5:

Now select the path in which the dependencies of package will install and then click next.In this window check the summary and click finish.Now you are done with your deployment.You can check by log in in target server Sql server Management studio.connect to integration services and under stored packages.You can find your deployed package.


No comments:

Post a Comment

EMP, DEPT Sample script

/****** Object:  Table [dbo].[DEPT]    Script Date: 19-05-2016 06:58:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET A...