I am trying to run a 3 step DTS package from VB .NET. It exports a SQL 2000
table to a dBase IV file.

Step 1: Drop table: succeeds
Step 2: Create table: succeeds
Step 3: Transform Data Task SELECTS all columns from the SQL 2000 table &
INSERTS it into the dBASE IV table. Fails with
Error: -2147467259
"SQL Server does not exist or access denied."

If I run the DTS package (either in whole or step by step), it runs without
error.

--
Tyler

Is it failing as a job and succeeds manually? When running as a job the
package is running on the server box not on your client machine. So you need
to make sure the server box can see all the data sources as well.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Tyler" <tylerf(REMOVETHISPART)@bocafed.org> wrote

I am trying to run a 3 step DTS package from VB .NET. It exports a SQL 2000
table to a dBase IV file.

Step 1: Drop table: succeeds
Step 2: Create table: succeeds
Step 3: Transform Data Task SELECTS all columns from the SQL 2000 table &
INSERTS it into the dBASE IV table. Fails with
Error: -2147467259
"SQL Server does not exist or access denied."

If I run the DTS package (either in whole or step by step), it runs without
error.

--
Tyler

just to add...the error you posted, occurs when an SQL Server with the
specified name is not available or not running or the server name is
misspelt.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Tyler" <tylerf(REMOVETHISPART)@bocafed.org> wrote

I am trying to run a 3 step DTS package from VB .NET. It exports a SQL 2000
table to a dBase IV file.

Step 1: Drop table: succeeds
Step 2: Create table: succeeds
Step 3: Transform Data Task SELECTS all columns from the SQL 2000 table &
INSERTS it into the dBASE IV table. Fails with
Error: -2147467259
"SQL Server does not exist or access denied."

If I run the DTS package (either in whole or step by step), it runs without
error.

--
Tyler

The DTS package fails on the last of 3 steps when I try to run it from VB
..NET using this command:
pkgTYCopy__ExternalTables.Execute()

The step that fails is a Transform Data Task that SELECTS all columns from
the SQL 2000 table & INSERTS them into the dBASE IV table.
The first 2 steps are a DROP TABLE and a CREATE TABLE.

It succeeds when I run it from SQL Enterprise Manager; either step by step
or as a whole.

The DTS package is saved on the SQL Server.

The dBase IV table is being written to a mapped drive & the SQL Server has
that mapping.

TIA
--
Tyler


"Narayana Vyas Kondreddi" wrote: