Re: DTS Error - Provider Error???

#1

Any Rhyme or reason?
Can you have the packages log to text file and see if we can get a better
error

Do you use any VB component (home grown or the OLAP task)?

"-2147352567 is the error number VB uses for a passed in error that it does
not understand. Basically, it means some method in some object failed to
work properly but VB does not know what, where or why."

Do the packages work individually?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Lanny Sutton" <lsutton (AT) us (DOT) loreal.com> wrote

Quote:

OK, here we go...

Platform: SQL Server 7.0 on Windows NT 4 SP6a

I have several DTS packages scheduled to run from one Agent Job. The
packages are all accessing the same data source. Some of my packages will

complete while others give the following error. Does anyone have any
suggestions as to my problem?

Quote:

DTSRun: Loading... Error: -2147352567 (80020009); Provider Error:
0 (0) Error string: Exception occurred. Error source:

Microsoft Data Transformation Services (DTS) Package Help file:
sqldts.hlp Help context: 705. Process Exit Code 1. . NOTE: The step
was retried the requested number of times (2) without succeeding. The step
failed.

Quote:

Thanks,

Lanny Sutton

#2

maybe things just got a little fuzzy and a restart of SQL Server put it
right

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Lanny Sutton" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Actually, I stopped and re-started the SQL Server service and the problem
stopped.

I suppose this is equivalent to Start ~ Shut Down ~ Reboot!

Lanny Sutton

----- Allan Mitchell wrote: -----

Any Rhyme or reason?
Can you have the packages log to text file and see if we can get a
better
error

Do you use any VB component (home grown or the OLAP task)?

"-2147352567 is the error number VB uses for a passed in error that
it does
not understand. Basically, it means some method in some object
failed to
work properly but VB does not know what, where or why."

Do the packages work individually?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Lanny Sutton" <lsutton (AT) us (DOT) loreal.com> wrote in message
news:F97E33C7-44CB-43F1-98A3-EA7D8C29F5D9 (AT) microsoft (DOT) com...
OK, here we go...
Platform: SQL Server 7.0 on Windows NT 4 SP6a
I have several DTS packages scheduled to run from one Agent Job.
The
packages are all accessing the same data source. Some of my packages
will
complete while others give the following error. Does anyone have any
suggestions as to my problem?
DTSRun: Loading... Error: -2147352567 (80020009); Provider
Error:
0 (0) Error string: Exception occurred. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts.hlp Help context: 705. Process Exit Code 1. . NOTE:
The step
was retried the requested number of times (2) without succeeding.
The step
failed.
Thanks,
Lanny Sutton

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

Re: DTS Error - Provider Error???

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

Re: DTS Error - Provider Error??? - 01-24-2004 , 01:14 AM

Re: DTS Error - Provider Error??? - 01-26-2004 , 08:41 AM