Solved

SSIS/DTSX Physical Package Location

Posted on 2007-04-03
2
259 Views
Last Modified: 2013-11-30
Hi All,

We have just created a new SQL 2005 server and have imported all our old DTS packages from a 2000 server and migrated them to DTSX packages using the migrate function. We need to make some changes to them but cannot locate the files on the sql server.

Where are the DTSX package files actually stored on the server or can be viewed in management studio?

We are using the standard version of 2005 so I know they are there somewhere.

Cheers
0
Comment
Question by:DtBarlow
  • 2
2 Comments
 
LVL 2

Expert Comment

by:SLaneDell
ID: 18841879
Hi Barlow,

The SSIS Packages can be stored in a standard directory or an SQL Server Package Store,, to access the packages in the package store, connect to Integration services with sql server management studio, i.e. instead of chosing Database Engine on the logon screen chose Integration Services, you then can access stored packages from there, if they are stored in a standard directory, just search for *.dtsx files on you machine

Steve
0
 
LVL 2

Accepted Solution

by:
SLaneDell earned 125 total points
ID: 18841888
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

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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

914 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

17 Experts available now in Live!

Get 1:1 Help Now