Solved

I need help deploying an SSIS package

Posted on 2014-09-18
4
175 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 45

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 45

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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 extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

744 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

11 Experts available now in Live!

Get 1:1 Help Now