Thursday, March 29, 2012

edit a DTS package in sql 2005?

How do you edit a DTS package that has been migrated to SQL 2005 from SQL
2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
can't quite figure out how to edit it.
What are the steps to follow to do this? If it's possible.
Thanks!Per the SQL Server 2K5 Upgrade Advisor
You can use SQL Server 2005 tools to edit your existing DTS packages.
However, upgrading or uninstalling the last instance of SQL Server 2000 on a
computer removes the components required to support this feature. You can
retain or restore these components by installing the special Web download,
â'SQL Server 2000 DTS Designer Components,â' before or after you upgrade or
uninstall SQL Server 2000.
"mp3nomad" wrote:
> How do you edit a DTS package that has been migrated to SQL 2005 from SQL
> 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
> can't quite figure out how to edit it.
> What are the steps to follow to do this? If it's possible.
> Thanks!|||thanks!
"Mark H" wrote:
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> â'SQL Server 2000 DTS Designer Components,â' before or after you upgrade or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:
> > How do you edit a DTS package that has been migrated to SQL 2005 from SQL
> > 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
> > can't quite figure out how to edit it.
> >
> > What are the steps to follow to do this? If it's possible.
> >
> > Thanks!|||I tried installing this component and I'm getting error messages trying to
open the legacy DTS package. I also have the backward compatibility
components installed as well. Is there something I'm missing here?
What are the steps to follow to move a DTS package from SQL 2000 to SQL 2005
and then edit the package on the SQL 2005 server?
"Mark H" wrote:
> Per the SQL Server 2K5 Upgrade Advisor
> You can use SQL Server 2005 tools to edit your existing DTS packages.
> However, upgrading or uninstalling the last instance of SQL Server 2000 on a
> computer removes the components required to support this feature. You can
> retain or restore these components by installing the special Web download,
> â'SQL Server 2000 DTS Designer Components,â' before or after you upgrade or
> uninstall SQL Server 2000.
>
> "mp3nomad" wrote:
> > How do you edit a DTS package that has been migrated to SQL 2005 from SQL
> > 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but
> > can't quite figure out how to edit it.
> >
> > What are the steps to follow to do this? If it's possible.
> >
> > Thanks!

No comments:

Post a Comment