Solved

SSIS/DTSX Physical Package Location

Posted on 2007-04-03
2
254 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.

707 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

19 Experts available now in Live!

Get 1:1 Help Now