로그인
 
홈라이브러리학습다운로드지원커뮤니티포럼

none
HI Friends ! How we do Single package deployment to IS Catalog

 > 

    질문

  • Question
    로그인하여 투표
    0
    로그인하여 투표

    HI Friends we have already Deployed SSIS Project to IS Catalog. Which Project has 4 packages. one package we had changed some tasks. So My requirement is We need to deploy that Edited package to IS catalog In 2012 is it possible.

    I am doing File system deployment Thanks for advance. Can you please give us your valuable Answers.

    2013년 12월 11일 수요일 오후 10:30
    |
    |

모든 응답

  • Question
    로그인하여 투표
    1
    로그인하여 투표
    I have my doubts it is possible,  if you need to have them in the Catalog you need to deploy the entire project.

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    2013년 12월 12일 목요일 오전 6:28
    |
    |
  • Question
    로그인하여 투표
    0
    로그인하여 투표

    we Able to deploy Entire project but we are not able to deploy Single package to IS Catalog. 

    Thanks for your Reply Uri Dimant
    2013년 12월 13일 금요일 오후 3:39
    |
    |
  • Question
    로그인하여 투표
    2
    로그인하여 투표

    Hi,

    The short answer is no.

    In SQL 2012, Integration Services supports two deployment models, the project deployment model and the package deployment model. The project deployment model enables us to deploy our projects to the SSISDB catalog on an instance of SQL Server. In project deployment model, a project is the unit of deployment which means that all the packages in the project will be deployed.

    If we right click on the \SSISDB\<FolderName>\Projects\ folder, we can see the “Import Packages…” option which allows us to import a single package. However, this method actually creates a new project to host the specified package (it can be one or more packages created in a SSIS project) and create an .ispac deployment file for the project, and then deploy the new project. If you choose this method to import the edited package to the existing folder in the SSISDB, it will overwrite the existing project folder and cause packages loss. So, the only way is to redeploy the whole SSIS project to overwrite the existing SSISDB project folder currently.

    If you have concerns on that, I would suggest you submitting a wish at https://connect.microsoft.com/sql.

    Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

    Regards,

    Mike Yin
    TechNet Community Support

    2013년 12월 15일 일요일 오후 1:21
    |
    |
    중재자
  • Question
    로그인하여 투표
    0
    로그인하여 투표
    See this article by Matt Masson:
    http://www.mattmasson.com/2012/07/can-i-deploy-a-single-ssis-package-from-my-project-to-the-ssis-catalog/

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    2013년 12월 15일 일요일 오후 3:11
    |
    |
    중재자
  • Question
    로그인하여 투표
    0
    로그인하여 투표
    Thank you very much MIKe Yin for your time reply to me 
    2013년 12월 16일 월요일 오후 12:36
    |
    |
  • Question
    로그인하여 투표
    0
    로그인하여 투표

    Thanks for reply to me 

    2013년 12월 16일 월요일 오후 12:37
    |
    |