Hi All,

I am able to execute the DTS from Stored procedure (including Passing Global
Variables). I use DTSRUN using xp_cmdshell. But some time (mainly the very
1st time from other system) I get the folowing ERROR. But next time onward
that works fine. Can any body suggest why this happens?

__________________________________________________ _____________________
Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure

Step Error code: 8007FFFF
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700

Step Execution Started: 6/15/2004 9:24:36 PM
Step Execution Completed: 6/15/2004 9:24:38 PM
Total Step Execution Time: 1.802 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded
Step Execution Started: 6/15/2004 9:24:36 PM
Step Execution Completed: 6/15/2004 9:24:36 PM
Total Step Execution Time: 0.21 seconds
Progress count in Step: 0

__________________________________________________ _________

Thanks
Prabhat

Anything special about the datapump? Funky source or destination? Drivers
installed OK? Anything specal about when you execute things and it fails?



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote

Hi Sir,

The Data Source is dbase5 and destination is SQL Server.
Drivers are OK, As This works fine. Only for 1st time (some time) it fails
with that ERROR.
I execute the Package from Stored Procedure using DTSRUN and xp_cmdshell and
Pass Global Variables.

My Package uses Global Valiables and Dynamic Mapping (Source Path, Source
dbf File, Destination Server, Destination Database, Destination Table etc.)

Any Suggestions.

Thanks
Prabhat


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

The only real thing I can think that might be happening is some kind of
connection issue with the dBaseV database. Is this intermittent i.e. no
Rhyme or Reason?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote

Probably Yes, as this heppens only for 1st time from a system, even some
time that does not happen.

Thanks
Prabhat

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Sir,

Is their any Solution to that?

Thanks
Prabhat

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Unless you can narrow down a situation in which you can consistently fail
things then it will be very difficult to troubleshoot

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote

Hello Sir,

Shall I send U the Package and the SP which is used to call that? So That U
can Guess.
for Source dbf Path I send UNC Path.

Thanks
Prabhat


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Sir,

I think I have Solved that (Catastrophic failure) problem.

I was using one Gloabl Variable "gLineNumber" of String Type and was
Incrementing that Valiable while Inserting for Each dbf file.
I think as I was incrementing the String Variable with +1 so I was getting
that problem. I am not sure if that was causing the Problem. Please Suggest
is that was the problem?

BUT now I have Another problem instead of that: (This is also same occurs
only 1st time - that to again very rare case) (As I was not capturing the
Error earlier so i was not getting the ERRORS. As Now I am Capturing Errors
using LOG Files so I am able to Get these all)
----------------------------------------------------------------------------
--
Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft JET Database Engine
Step Error Description:'H:\PA_Files\SRO' is not a valid path. Make sure
that the path name is spelled correctly and that you are connected to the
server on which the file resides.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003044

Step Execution Started: 6/16/2004 7:47:41 PM
Step Execution Completed: 6/16/2004 7:47:43 PM
Total Step Execution Time: 1.542 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded
Step Execution Started: 6/16/2004 7:47:41 PM
Step Execution Completed: 6/16/2004 7:47:42 PM
Total Step Execution Time: 0.29 seconds
Progress count in Step: 0
----------------------------------------------------------------------------
----------

I have used the above path 'H:\PA_Files\SRO' in the DTS Package while I
designed the package for the Data Source for my dbf Connection (Source
Connection).
But I am using a Global Variable "gSourcePath" and Passing Value to that
Variable from the Stored procedure. Also I am Assigning the Value to the
"DataSource" property of the dbfConnection by using the Dynamic Mapping
Task. "I Pass UNC Path of the dbf File to that Variable".

That is working fine. Becuase my package fails by giviing the above error
only some time - say the very first time - that to again very rare.

Any Help or Suggestions.

Thanks
Prabhat

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

If it is only happening the first time then does it give the correct
location as the error or is it the previous location?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Prabhat" <not_a_mail (AT) hotmail (DOT) com> wrote