MS SQL Server DTS - DTS Package fails on last step

Author

DTS Package fails on last step

Tyler

2005-07-22, 11:23 am

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

Narayana Vyas Kondreddi

2005-07-22, 11:23 am

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(REMOVETHISPAR
T)@bocafed.org> wrote in message
news:6ED4B8F7-40AD-48AB-96AA- F20737180238@microso
ft.com...
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

Narayana Vyas Kondreddi

2005-07-22, 11:23 am

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(REMOVETHISPAR
T)@bocafed.org> wrote in message
news:6ED4B8F7-40AD-48AB-96AA- F20737180238@microso
ft.com...
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

Tyler

2005-07-22, 8:23 pm

The DTS package fails on the last of 3 steps when I try to run it from VB
..NET using this command:
pkgTYCopy__ExternalT
ables.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:

> 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(REMOVETHISPAR
T)@bocafed.org> wrote in message
> news:6ED4B8F7-40AD-48AB-96AA- F20737180238@microso
ft.com...
> 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
>
>
>

Sponsored Links