Solved

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

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql server function help 15 31
insert wont work in SQL 14 22
Sql server, import complete table, using vb.net 9 36
SQL - Update field defined as Text 6 17
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

832 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