Solved

I need help deploying an SSIS package

Posted on 2014-09-18
4
212 Views
Last Modified: 2016-02-11
Hi Experts,
I have updated an SSIS package in SQL Server Business Intelligence Development Studio.  Now that I have made my updates how I build it and deploy it/roll it out?

Thanks in advance,
mrotor
0
Comment
Question by:mainrotor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 167 total points
ID: 40331942
Hi,

This Article will help you to done the deployment Step by step

After build one manifest file will be created which will be used for deployment

http://technet.microsoft.com/en-us/library/ms140117%28v=sql.105%29.aspx
0
 
LVL 49

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 166 total points
ID: 40332066
There's no Build for SSIS packages like building an application in C# or .NET.
You can use the deploy option as Vikas posted the link if you aren't working in the SSIS server and then depending where are you storing the package (database or file) you just need to define a job in SQL Server Agent to run the package. When you create a job just specify that's a SSIS package and fill the fields with the necessary information.
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 167 total points
ID: 40336261
Vitor, There is Build and Rebuild feature available for SSIS package. When you biuld it will create deployment package (Manifest file for 2008 and ispac file for 2012).

If you set deployment package property to TRUE for SSIS 2008 then it will do for manifest file.

Using that file you can deploy you packages to File system, SQL Server and Integration Catalog (for SQL Server 2012 )
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 40336307
There's no Build for SSIS packages like building an application in C# or .NET.
With this statement I wanted to mean build an EXE file. The rest (manifest file) it's in the link that Vikas posted.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question