You should be able to access a DTS package (Of course created in SQL Server 2000) using the Execute DTS 2000 package task. You need to provide all relevant information regarding the package, its storage location, permissions, etc.
If you want to migrate a package to SSIS then you may do so from Project-->Migrate DTS 2000 Package.
No comments:
Post a Comment