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