How to view DTS Package

Question

Hello All,

I have 5 dts packages. They are scheduled to run everyday.I need to create those 5 dts packages in SSIS 2005 and will be able to run properly. First I want to take a look at those dts packages so that I know what sources, transformations, and destinations are used and it will help me to create SSIS packages. Can anyone tell me how to achieve this.

Thanks

Answer 1

Hi, check this article:

http://msdn.microsoft.com/en-us/library/ms143755.aspx

David.

Answer 2

Install the DTS Designer components for SQL 2005 or SQL 2008 depending upon the version that you are using.

Answer 3

Thanks so much.Installing DTS designer components is just enough? or do I need anything else?. Because in the article they have mentioned to install the run time components. I am really new to dts. Please help.

Thanks

Answer 4

If you just want to view the DTS packages, the designer components would be enough. Runtime components would be required if you want to run those DTS packages.

Answer 5

Thanks so much. If I want to make some changes to that dts package, I need to install run time components and  need to use upgrade wizard and convert them to SSIS 2005 packages right?

Answer 6

If your end result is having the SSIS formated packages (upgraded and migrated), then do not bother installing the DTS support at all, just create a new SSIS project, run the upgrade wizard and you will be able to modify the upgraded [SSIS] package.

Otherwise you do need the both aforementioned items.

---

Arthur My Blog

Answer 7

Sure. Thanks so much. One last question. I have some errors in dts package.What is the best method to actually see those erros and resolve.

Answer 8

I guess you already see them. To see what kind of errors? Run time or design time? At design time just depends what component shows it, you typically doubleclick on the entry. At run time and always you should enable logging on the package level in the package properties the last tab.

---

Arthur My Blog