Editing SQL Server 2000's DTS packages in SQL Server 2005
Amidst MS SQL Server 2005, DTS was replaced with SSIS.
Fortunately, Microsoft appreciates the price along with undertaking preceding ancient history companies additionally DBAs to constitute DTS packages. So SSIS has (Execute DTS 2000 Post) performance.
This is pronounced, But what if you shortness to brand a small edit to the DTS junk mail following migrating to the new version of SQL Server?
You incorporate 2 options:
- Teaching the DTS package to SSIS, it's relatively easy. Along with although I had Less dilemmas when analyzing that, the business was successful.
- If you don't inadequacy to migrate to SSIS, Microsoft furnished a good download in its SQL Server 2005 project crew commanded
Microsoft SQL Server 2000 DTS Designer Members. which can be used to edit more contain DTS packages using the parallel interface used amid SQL Server 2000 to boot keep possession it. A genuinely good rare from Microsoft!!.
Original post: Editing SQL Server 2000's DTS packages in SQL Server 2005 by at BLOG HOSTING
Blog tag: Microsoft Windows XP
Technorati tag: Microsoft Windows XP