Solved

I need help deploying an SSIS package

Posted on 2014-09-18
4
179 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
  • 2
4 Comments
 
LVL 14

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 46

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 46

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now