Solved

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

Posted on 2014-09-15
2
135 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

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…
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.
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

911 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

22 Experts available now in Live!

Get 1:1 Help Now