Who is online?  256 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  SSIS - Creating a Deployment Manifest

SSIS - Creating a Deployment Manifest

change text size: A A A

posted  11/7/2009 2:10:01 PM  by DevinKnight

Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages.  The benefit to using it is the nice user interface that a wizard provides.  The disadvantage of using it is it’s lack of flexibility.  When using the Deployment Manifest keep in mind that it’s an all or nothing deployment, which means you cannot choose to just deploy one or two packages at a time from your SSIS project.  Using the Deployment Manifest will deploy all your packages that are in your project.  Creating the manifest file is a very simple process that I will walk you through.

For more information about Managing and Configuring SSIS package download this whitepaper I co-authored on the topic.  http://www.pragmaticworks.com/downloads/ssiswhitepaper/downloadwhitepaper.aspx

Creating a Deployment Manifest

 

  • With the Solution Explorer open Right-Click on the project name and click Properties
  • This will open the Project Properties Pages

 

  • Select the Deployment Utility from the page
  • Change the CreateDeploymentUtility property to True

After you’ve gone through these steps the next time you build your project it will create the file (YourProjectName).SSISDeploymentManifest.  This file is located in the same folder as your packages in the bin\Deployment folder.

If you run this file it will open the Package Installation Wizard that will allow you to deploy all your packages that were located in the project to a desired location.

tags :   SSIS
  Rate This Blog Entry:  register  or  login

Author

DevinKnight DevinKnight (Member since: 10/27/2009 11:25:07 AM)
Devin (MCTS, MCITP) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin helps run his local users’ group (JSSUG) as a Vice President.

View DevinKnight 's profile

Comments (no comments yet)

Leave a comment


 
Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

Blogs RSS Feed

DevinKnight's latest blog posts

  • MDX - Calculating the Percent of a Named Set
    1 hours, 32 minutes ago by DevinKnight  - Views: 18  - Comments: 0
    Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built in. In this example a named set has been added and the requirement i...
  • Creating a PerformancePoint 2010 Data Source
    9/1/2010 3:23:11 AM by DevinKnight  - Views: 2859  - Comments: 0
    In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010. Your next steps are to con...
  • SQL Lunch #26 Analysis Services Security
    8/5/2010 12:31:25 PM by DevinKnight  - Views: 326  - Comments: 0
    Today at 12:30 EST I will be presenting for SQL Lunch on the topic of Analysis Services Security. Make sure to be there to learn how to create dynamic or table based security in SSAS. Speaker: Devin K...
  • Getting Started With PerformancePoint 2010
    8/3/2010 4:01:47 PM by DevinKnight  - Views: 666  - Comments: 2
    PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also has the ability to dig into the details. It makes it simple to create quick dash...
  • SSIS - Event Handler Performance
    7/20/2010 2:40:22 AM by DevinKnight  - Views: 322  - Comments: 0
    Event handlers are a great tool for managing errors and other events that occur during the execution of a package run. Using event handlers can however add additional time to the run of a package. Dep...
  • SSAS Cache Warming with an SSIS package
    7/1/2010 11:26:49 AM by DevinKnight  - Views: 504  - Comments: 3
    There are several techniques that can be used for performance tuning Analysis Services. You may already be familiar with the typical methods used like Partitions and Aggregations . However, an often f...
  • MDX webinar
    6/24/2010 6:43:01 PM by DevinKnight  - Views: 224  - Comments: 0
    Today I did a webinar on MDX solution. For those of you interested you can grab the slides here and code example here . If you missed the session you can also download the recording here . We do month...
  • SSIS R2 Configuration File Issue Fixed
    5/14/2010 1:30:51 PM by DevinKnight  - Views: 544  - Comments: 3
    Using configurations files in SSIS is a great way to change how your package will run from outside the development environment. One thing that I’ve always recommended when using files (I actually pref...
  • Reporting Services 2008 R2 Report Parts
    4/24/2010 7:59:40 PM by DevinKnight  - Views: 1035  - Comments: 0
    Reporting Services 2008 R2 has many new great features that I’ve written about lately ( Data Bars and Indicators ). Today I wanted to tell you a little about another nice add called Report Parts. Repo...
  • SQL Saturday #38 Jacksonville Update
    4/15/2010 1:03:41 PM by DevinKnight  - Views: 435  - Comments: 0
    With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside information about this event if you've never been to one before. SQL Saturday is a free tr...
  • Reporting Services 2008 R2 Data Bars
    4/13/2010 12:30:27 AM by DevinKnight  - Views: 1459  - Comments: 1
    Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be help for displaying KPIs in Reporting Services. Today I want to looks at another nice fe...
  • Reporting Services 2008 R2 KPI ready
    4/9/2010 7:06:06 PM by DevinKnight  - Views: 2369  - Comments: 1
    As I begin to explore more and more of the new feature that will be available in SQL Server 2008 R2 I can’t help but think why was this not available before? One of these features is the new item in t...
  • Auditing Report Executions with Free Source Code
    3/30/2010 1:28:36 PM by DevinKnight  - Views: 2230  - Comments: 2
    Have you been looking for a way to measure report performance? Want to know who accesses your reports most frequently? Well there are some free reports on http://msftrsprodsamples.codeplex.com/ that y...
  • Using SSAS MDX Calculation Color Expressions
    3/17/2010 12:10:25 AM by DevinKnight  - Views: 3479  - Comments: 9
    Analysis Services calculations are great for storing formulas that your users need to see on a regular basis. They also have another little feature that adds just a little more wow when your end users...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM by DevinKnight  - Views: 1372  - Comments: 0
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters. Anytime you have a parameter that allows...
  • Using Excel 2007 in SSIS 2005
    3/2/2010 10:16:14 PM by DevinKnight  - Views: 3132  - Comments: 2
    Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This results in the majority of companies still running previous versions of SQL Server (2005, 20...
  • Using Database Transactions across multiple SSIS Tasks
    3/2/2010 8:17:55 AM by DevinKnight  - Views: 1050  - Comments: 2
    If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. For example, if you have a transaction running on an entire package some tasks may no...
  • IntelliSense Slow to Refresh
    2/23/2010 11:36:14 AM by DevinKnight  - Views: 534  - Comments: 0
    IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more problems than it does solve problems. Here’s one of those problems cases: Create ...
  • Free Webinar Series This Week
    2/22/2010 6:50:40 PM by DevinKnight  - Views: 426  - Comments: 0
    If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. This series is meant to get you up to speed on many topics like TSQL, DBA Fundamentals,...
  • Development Lifecycle Deployment SSAS, SSRS, SSIS
    2/17/2010 10:26:07 AM by DevinKnight  - Views: 1078  - Comments: 0
    Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these environments (Development, UAT, and Production) can be a nightmare to main...
  • Foundation Class Review
    2/12/2010 10:22:46 PM by DevinKnight  - Views: 352  - Comments: 0
    This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite and most rewarding classes to teach. This class is designed to help individuals who ha...
  • Pragmatic Works Foundation Class Introduction
    2/9/2010 8:38:56 AM by DevinKnight  - Views: 1446  - Comments: 0
    You may have noticed a flux of new blog post entires yesterday from a group of people talking about the Pragmatic Works Foundation. This is a great group of people that are new to IT and learning the ...
  • SSRS Commonly Required Date Expressions
    2/5/2010 2:01:40 PM by DevinKnight  - Views: 2145  - Comments: 1
    Reporting Services has many expressions that can manipulate date fields. These expressions can be used just about anywhere in SSRS including object properties, displayed data, and parameters. Recently...
  • Handling Escape Sequences in SSIS Expression String Literals
    1/27/2010 1:18:27 PM by DevinKnight  - Views: 1877  - Comments: 3
    The SSIS expression language is a powerful tool for a developer that gives you one method of making a package dynamic. When writing an expression there are a few things to be careful of that could pot...
  • SSIS Checkpoints with Tasks Running in Parallel
    1/22/2010 1:40:42 PM by DevinKnight  - Views: 851  - Comments: 2
    Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every feature there are potential problems you can run into and it is no different with Checkpoints...
Blogs RSS Feed

Latest community blog posts

  • MDX - Calculating the Percent of a Named Set
    1 hours, 32 minutes ago by DevinKnight  - Views: 18  - Comments: 0
    Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built in. In this example a named set has been added and the requirement i...
  • Restarting SQL Server using a Batch Script
    8/29/2010 5:17:21 PM by briankmcdonald  - Views: 27  - Comments: 0
    In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of SQL Server using the SSMS GUI. Again, please do not execute this on your PRODUCTION server, but h...
  • Where do you get your motivation and drive?
    9/6/2010 7:04:58 PM by PatrickLeBlanc  - Views: 48  - Comments: 3
    I was asked by someone the other day, where do you get your drive and motivation? For a second, I was stumped. After giving it a little thought I realized that my drive has several sources. The first ...
  • SQLMotivation for your Monday
    9/6/2010 3:39:24 PM by AdamJorgensen  - Views: 28  - Comments: 0
    Motivational time again! Today I want to talk about being lazy with your data. More likely than not, it’s not your data, it’s your firm’s data. Make sure you’re taking precautions. There are so many f...
  • Breaking in (Entry level advice)
    9/3/2010 1:44:17 PM by sqlscottgleason  - Views: 34824  - Comments: 3
    How does one get started in this field? One thing that I see from time to time is someone who just keeps taking class after class hoping that a resume full of classes will make their resume took impre...
  • MDX Puzzle #7 - Solution
    9/3/2010 1:23:35 PM by PatrickLeBlanc  - Views: 10752  - Comments: 4
    Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed a currency type based on the existing currency code. As always, there are a couple of...
  • Script Indexes With Your Table
    9/3/2010 11:34:51 AM by BradSchacht  - Views: 2753  - Comments: 0
    Scripting tables inside of SQL Server Management Studio is a very simple task. Just right click and select script table. The problem is that, but default, the indexes on a table are not part of the sc...
  • Retrieving Report Names for SSRS Subscription Jobs
    9/1/2010 6:00:10 PM by briankmcdonald  - Views: 1405  - Comments: 0
    The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look at the jobs on the database server that Reporting Services is configured t...
  • Pirates of PASS: Curse of the Elections Process
    9/2/2010 6:52:12 PM by sqlchicken  - Views: 10113  - Comments: 3
    Pirate Code: They're more like guidelines really... The last few weeks we've watched the drama unfold in regards to the PASS BOD elections. We've seen people attack criticize the NomCom, the board, PA...
  • What are plan guides?
    9/2/2010 1:34:14 AM by indupriya  - Views: 6299  - Comments: 0
    Just a while ago I was watching a video on sqlshare Creating a Plan Guide for a Parameterized Statement By Andy Warren . Only then I heard about plan guides. I didn't know what plan guides were. Here ...
  • Did You Know..
    9/1/2010 8:22:35 PM by britmccullar  - Views: 6909  - Comments: 0
    Unfortunately, I don't have one big topic to write about in this post, so I decided to share some observations from the past few weeks - little things that might be of interest in the next report you ...
  • Creating a PerformancePoint 2010 Data Source
    9/1/2010 3:23:11 AM by DevinKnight  - Views: 2859  - Comments: 0
    In a previous post I wrote about getting started with PerformancePoint 2010. In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010. Your next steps are to con...