Re: DTS Error Message

#1

This was a problem on 7

http://support.microsoft.com/default...microsoft.com:
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

"mr_kotic" <mr_kotic (AT) hotmail (DOT) com> wrote

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

TSFFile.hlp
Step Error Help Context ID:0

Has anybody come across this one?

Thanks in advance for anyone's help.

M

#2

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.

#3

Please do not post the same message under different headings. See my reply
to your other one

--

----------------------------
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

"SCCP" <member42782 (AT) dbforums (DOT) com> wrote

Quote:

I have a problems of this... please help

Executed as user: MBADOMAIN\Administrator. .... DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_2 DTSRun OnError:
DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: ActiveX Scripting encountered a Run Time Error during
the execution of the script. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 4500 Error Detail Records: Error: -2147220482
(800403FE); Provider Error: 0 (0) Error string: ActiveX
Scripting encountered a Run Time Error during the execution of the
script. Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun: Package
execution . The step failed.

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Error Message

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS Error Message - 07-21-2003 , 06:24 AM

Re: DTS Error Message - 07-22-2003 , 08:55 AM

Re: DTS error message - 10-14-2003 , 01:23 AM