Questions tagged [sql-server-package]
2 questions
10
votes
3 answers
How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages?
I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that's not what I'm after). I receive the following error by running one of my…

Abel
- 56,041
- 24
- 146
- 247
0
votes
1 answer
Check DTS Package Info
In SQL Server 2005, I would check the version of my package like so:
USE [msdb]
GO
SELECT [Name], CAST([VerMajor] AS VARCHAR(4)) + '.' + CAST([VerMinor] AS VARCHAR(4)) + '.' + CAST([VerBuild] AS VARCHAR(4))
AS [Version]
FROM…

Needs Help
- 121
- 1
- 3
- 6