Finding DTS jobs in SQL 2005
-
So, I'm an intern trying to figure out SQL. My question is... how do I find the DTS jobs in SQL? I expanded management, legacy, then DTS, however, I'm not sure if those are the jobs listed.
-
Hi!
You need to start the SQL Server Agent.
Right click Jobs and add a new job.
-
Hi,
CASE 1: Start SQL Server Agent and see all Jobs for Packages
CASE 2: Run following command to view all Jobs
USE msdb;
SELECT * FROM SYSJOBS;
-
Awesome! I found the DTS jobs. My tasks is to document the packages. Does anyone know where I could go to figure out how to follow the process throughout the package?
-
What you see listed under Management--Legacy--Data Transformation Services are the DTS packages. Open one by right-clicking and select "Open...". Note: the SQL 2000 DTS Designer components must be installed on your computer before you can open a package. Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en.
You can figure out what the tasks and workflows are in the package by looking in BooksOnLine, but you may find it easier if you have a book like "Professional SQL Server 2000 DTS".
Greg
-
Great, thanks for all of your help everyone. 25 pages later I am almost done with the documentation. Gotta love being an intern
-
Hi
You can find SSIS Documentation Generator for SQL Server 2005 free of cost. Please see following link.....
http://www.ssisdocumenter.com/download/SSISDocumenterSetup.msi
Thanks
Bhudev
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply