Hi,

I migrated DTS packages into SSIS. Now how do I modify them in sql 2005
after migration.

Thanks

mecn,

If you want to modify them as DTS 2000 packages you need to download
the DTS Designer component. It allows you to modify DTS 2000 packages
from sql2005. It can be found with a little internet searching.

If you want to convert them to ssis projects then you must use the sql
server business intelligence develoment studio. Just a
warning...convert dts 2000 packages to SSIS is far from perfect. It's
almost like redoing the whole package and may even be easier to rewrite
the package from scratch using SSIS. But you can keep them in dts 2000
form and maintain them from sql server 2005.


Jason


mecn wrote:

Thanks, Jason
I appreciated your help.



"Jay" <JasonPirtle (AT) gmail (DOT) com> wrote

I've migrated to SSIS sql 2005. I need to modify the SSIS packages. How do I
open them in visual studio or other designer to to changes?

Thanks


"Jay" <JasonPirtle (AT) gmail (DOT) com> wrote

1. Open Sql Server Management Studio
2. Click File Menu and select Connect Object Explorer
3. For Server Type: Select Integration Services
4. For Server Name: Type in the name of your 2005 server

In the object server you should see Integration Services. Your
packages are probably stored under the MSDB tree node. I'm not sure of
all the ways to modify them from there, but what I've done is export it
to a File and then you can use the Business Intelligense Studio to
modify them.

Let me know if this works.

Jay

mecn wrote:

Thanks Jay,

How do I export it to a file?
Could list the details for me pls.
I tried export package then I could do it.
Thanks,


"Jay" <JasonPirtle (AT) gmail (DOT) com> wrote

Jay,

Never mind. What I did was export package them select to files ystem
Thanks


"mecn" <mecn2002 (AT) yahoo (DOT) com> wrote