Hi, I am new to this forum and new to SSIS. I want to know how I can convert an old DTS package to SSIS. Thanks

You can convert Dts to SSIS using Migration wizard but there is a program called DTS xChange, It works with a much higher ratio of success than the built in one. DTS xChaange has converted more than 200k packages successfully. you can also download demo version from this website http://pragmaticworks.com/Products/Business-Intelligence/DTSxChange/Default.aspx For basic information you can refer following article. http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/