DTS Error Message 
Author Message
 DTS Error Message

Hi,

During the last seven days a set of DTS packages have started failing.
Re-running the jobs will often get them through.  Nothing has changed
on the box that I am aware of and the size of the files has not
increased dramatically.

System config is:

SQL Server 2000 Enterprise Edition SP3.

The error from the Package Logs is as follows:

Step Error Source: Microsoft Data Transformation Services Flat File
Rowset Provider
Step Error Description:Error creating file mapping view: Insufficient
system resources exist to complete the requested service.

Step Error code: 80074005
Step Error Help File:DTSFFile.hlp
Step Error Help Context ID:0

Has anybody come across this one?

Thanks in advance for anyone's help.

M



Fri, 06 Jan 2006 18:21:23 GMT
 DTS Error Message

This was a problem on 7

http://support.microsoft.com/default.aspx?scid=http://support.microso...
80/support/kb/articles/Q221/5/13.asp&NoWebContent=1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Quote:
> Hi,

> During the last seven days a set of DTS packages have started failing.
> Re-running the jobs will often get them through.  Nothing has changed
> on the box that I am aware of and the size of the files has not
> increased dramatically.

> System config is:

> SQL Server 2000 Enterprise Edition SP3.

> The error from the Package Logs is as follows:

> Step Error Source: Microsoft Data Transformation Services Flat File
> Rowset Provider
> Step Error Description:Error creating file mapping view: Insufficient
> system resources exist to complete the requested service.

> Step Error code: 80074005
> Step Error Help File:DTSFFile.hlp
> Step Error Help Context ID:0

> Has anybody come across this one?

> Thanks in advance for anyone's help.

> M



Fri, 06 Jan 2006 19:24:44 GMT
 DTS Error Message
In addition to my last post it would appear that the error matches your
situation exactly.  The OS and version of SQL Server do not.

Is this reproducable ?

If it is then it may well be worth aping to PSS

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Quote:
> Hi,

> During the last seven days a set of DTS packages have started failing.
> Re-running the jobs will often get them through.  Nothing has changed
> on the box that I am aware of and the size of the files has not
> increased dramatically.

> System config is:

> SQL Server 2000 Enterprise Edition SP3.

> The error from the Package Logs is as follows:

> Step Error Source: Microsoft Data Transformation Services Flat File
> Rowset Provider
> Step Error Description:Error creating file mapping view: Insufficient
> system resources exist to complete the requested service.

> Step Error code: 80074005
> Step Error Help File:DTSFFile.hlp
> Step Error Help Context ID:0

> Has anybody come across this one?

> Thanks in advance for anyone's help.

> M



Fri, 06 Jan 2006 19:26:27 GMT
 DTS Error Message
Allan,

Unfortunately, the problem is not reproducible, today the jobs ran
without a hitch.  Indeed, when the job does fail, merely re-running it
is sufficient.
Furthermore, when the jobs do abend they are not abending in the same
steps within the code.

Having read the article you suggest I'm not sure it's the same issue,
the jobs are scheduled to run on the server and the server is
reasonably speced for the task:

Server config:

Win2000 Advanced Server
SQL server 2000 EE SP3
7GB RAM
4 Processors

Files being processed by DTS jobs:

Largest File is 113MB in size with 9 more being an average of 50MB
Smallest File is 1K.
Each file is mapped one-to-one with a staging table.

The intention now is to continue monitoring the box and jobs.

Thanks for your suggestion.

regards,

M.



Sat, 07 Jan 2006 21:55:27 GMT
 DTS Error Message
I would run a trace against the box and also make sure that you have logging
enabled in the packages.  This gives you a reasonable chance of catching the
error.  It may also be worth capturing some server stats from Perfmon as
well.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Quote:
> Allan,

> Unfortunately, the problem is not reproducible, today the jobs ran
> without a hitch.  Indeed, when the job does fail, merely re-running it
> is sufficient.
> Furthermore, when the jobs do abend they are not abending in the same
> steps within the code.

> Having read the article you suggest I'm not sure it's the same issue,
> the jobs are scheduled to run on the server and the server is
> reasonably speced for the task:

> Server config:

> Win2000 Advanced Server
> SQL server 2000 EE SP3
> 7GB RAM
> 4 Processors

> Files being processed by DTS jobs:

> Largest File is 113MB in size with 9 more being an average of 50MB
> Smallest File is 1K.
> Each file is mapped one-to-one with a staging table.

> The intention now is to continue monitoring the box and jobs.

> Thanks for your suggestion.

> regards,

> M.



Sat, 07 Jan 2006 22:12:24 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Programming DTS from C++ - and DTS Error Messages

2. DTS error message in Event Log

3. Control-M - how to get DTS error messages?

4. DTS Error Message

5. DTS Error message

6. DTS error message when executing a package from Visual Basic

7. How to add custom DTS error messages?

8. DTS error message - cannot initialize script execution engine

9. Hello with DTS error message!!

10. Get DTS error messages to asp page

11. DTS error message - cannot initialize script execution engine

12. Can't interpret DTS error message


 
Powered by phpBB® Forum Software