I have a SQL 2000 server that has DTS' on it. I exported these manually to .dts and then imported them onto my other SQL 2005 server in Legacy >> Data Transformation Services. I've opened the legacy DTS' and run them and they seem to work. Now I need to schedule jobs to make them run automatically. Is it possible to do this and if so how? I went to "Jobs" under SQL Agent and can create a job but I can only select SSI packages. Any ideas?
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.