Solved

sql server 2012 how do I look at a SSIS package?

Posted on 2014-09-15
2
139 Views
Last Modified: 2016-02-11
What are the steps I take in sql server 2012 to look at a SSIS package?
0
Comment
Question by:tesla764
2 Comments
 
LVL 3

Accepted Solution

by:
prequel_server earned 500 total points
ID: 40324454
depends on where the package in stored. if on file server/windows then you find the package, right-click and open using sql server data tools.

If inside sql server,
1. open SSMS on the host server
2. change the connection type drop down to Sql server integration services
3.expand the trees until you find the package
4. right click on the package to edit or export to the file system to modify a copy of it
0
 

Author Closing Comment

by:tesla764
ID: 40325483
thanks
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

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