--------------------------------
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