> Hey. I've successfully migrated all the packages from server\instance1
> to server1\instance1. I read in one of the articles I've to change
> MsDTSSrvr.ini.xml file to see the migrated packages in SSMS. I did it
> and now i see the packages. But how would I edit the package I've
> migrated from server\instance1? what would I do if I had packages on
> server\instance2 which needed to be migrated to server1\instance2?
>
> Please give me more information or point me to a source. Thank you.
>

> I am in BID's and I go to file-->open. I dont see an option to open an
> existing package. I see a file and a solution but i know tht's not
> it... Am I missing somethng somewhere?? I also have the 2000 DTS
> Designer installed. What am i missing? Also, when I migrated them,
> everything was a success. Do I need to do anything or all of them will
> work fine in 2005? Thanks for the early reply, Allan.
>

"tpp" <tpp@discussions.microsoft.com> wrote in message
news:3160BBFE-2FC6-42AD-A76E-1B7FFB61E3C8@microsoft.com...
> Allright I'll give u a complete process of what i did. I have a server
> with a
> named instance on 2000(Server\instance1). I've a server with SQL 2005 with
> a
> named instance(server1\instance1). 2000 instance has the DTS packages. I
> right clicked Management | Legacy | Data Transformation Services and
> clicked
> on Migrate wizard and migrated all my DTS packages to server1\instance1.
> Then, I had to change the file 'MsDTSSrvr.ini.xml' and added the instance
> name in the file. I see the packages in sysDTSpackages90 table. I dont see
> them under 'Management | Legacy | Data Transformation Services' But once
> I
> changed the file and went to the Stored PAckages part of IS, I see the DTS
> packages. but I dont have the option to edit them. Alos, I dont see the
> option from BID. I dont have the complete feature pack but i do have
> 'Microsoft SQL Server 2000 DTS Designer Components' installed. Please tell
> me
> what i'm doing wrong. Thank you, Alan.
>
>

"tpp" <tpp@discussions.microsoft.com> wrote in message
news:0F974459-3652-47F4-AECB-7BD35FE63639@microsoft.com...
> Ok, so now I understand that I've to open the packages from SSIS to edit
> the
> package. When I open BID's do i create a new package and then import it in
> that? Also, once I edit the package in SSIS, is it possible to see it in
> the
> msdb folder for SSIS. Also, which one is better? To save it in msdb or
> file
> system now?

"tpp" <tpp@discussions.microsoft.com> wrote in message
news:3F214A75-9FD6-43E8-A52B-9933CD321D07@microsoft.com...
> Hey Allan. Thank you for your help so far. This is what I did to get what
> you
> said. First I created a new SSIS project. Then I deleted the dtsx file it
> created inside the project. Then I right clicked 'SSIS Packages' and
> clicked
> 'Add Existing PAckage' Then, I saw the dts packages from there and now can
> edit it. But is the first part necessary where I've to create a new
> project
> and delete the dtsx file and then do my stuff? Am I doing this right?
>
> Thank you very much, Allan.

> so, i see your point. I gues i want to import the DTS packages so i
> see them under the Legacy folder. How would i go about that? I tried
> to right click it and try to import but dont see an option that would
> do it. I did see an option where I can migrate but don't see it. Do
> you by any chance have a link which would help me IMPORT the packages
> so i can open thm in DTS to edit and then migrate them to SSIS at my
> leisure? If not, how do u import packages in IS from DTS and not
> migrate them? Thank you....
>

> In SQL 2000, we have everything residing in msdb. So, do i have to
> save all the packages to the file system before i can import them?
> Thank you very much for all your help, Allan.
>