DTS Package is Active
We have a SQL 7 and there are 11 DTS Packages present and the creation date is 2007. How can I know that these DTS Packages are active? And if they are active, what is the best way to move it to SQL 2012.
-
Moved by
Lydia ZhangMicrosoft contingent staff, Moderator
5 hours 20 minutes ago
more appropriate
September 10th, 2015 5:41pm
- Change the dts package properties to enable logging to SQL SERVER. When the package is executed, an entry will be added to the table : msdb.dbo.sysdtspackagelog and one entry per pckage task in the table msdb.dbo.sysdtssteplog. If the package is itself
saved to SQL SERVER, you can right click on it in Enterprise Manager and access the execution history.
- You also have to access the package properties and in the logging tab you choose to write completion status to the Windows Application Event Log. Analyzing the event log will give you clues on package execution history.
- Backup the old packages and rename the current packages to new name and then wait and see for few days if
anybody complains.
- Check the windows event application log to see if there is any entries for package execution.
- Is there any sql agent jobs scheduled with these packages ? you can verify the jobs as well.
September 10th, 2015 8:16pm