Tuesday, October 15, 2013

SSIS:Deployment using Project Deployment Model

Refer Source Video:SSIS 2012 Deployment using Project Deployment Model Video

--------------------------------
Prior:How to create a Catalog?
----------------------------------
Project Deployment Model  is new in 2012:
Folder file names: Package,Project.params,SSIS Project Deployment Model,SSIS Type Integration Services project file
----
Method1:Right click on project-choose Deploy
Server:Database Engine Server Name ( where SSISDB Catalog is their).
                        Path:SSISDB\Test

Copy the commandline parameter to Notepad.
The project is deployed to Database Engine(--verify)
Microsoft SQL Server Management Studio:
  Integration Services Catalogs-SSISDB-Test-Projects-SSIS Project Deploment Model-Packages-Package.dtsx
  SQL Server Agent
--
After running it the Bin\Deployment \ folder is created with file SSIS Project Deploment Model.
-----
Method2: Right click on Project Explorer->Build
Prior to choosing "Build" remove the Bin & Object folder

It will create Bin\Development , creates SSIS Project Deploment Model (Integration Services Deployment File) [Instead of running this , move to another Server & Run from their]
just double click the file it will run the wizard.( Same as Method 1 wizard)

Method3: Running from Commandline (---Notepad)
cd %ProgramFiles%\Microsoft SQL Server\..\Binn
isdeploymentwizard.exe  whatever copied for commandline

--Project deployment method whole Project is deployed not package wise.If any one modifying a package , make sure that latest one is compiled.

No comments:

Post a Comment