Solved

I need help deploying an SSIS package

Posted on 2014-09-18
4
190 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 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 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

813 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

13 Experts available now in Live!

Get 1:1 Help Now