Re: DTS Package fails on last step

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 in message
news:6ED4B8F7-40AD-48AB-96AA-F20737180238@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: how can I make money off my ultimate security solution for servers
    ... You should give a price to the first one that succeeds. ... and it fixes 100% percent of the current security problems with windows ... server in the world will be using some variation of my design. ... This is not just my opinion, I have shared this design with my friends ...
    (microsoft.public.windows.server.security)
  • Re: how can I make money off my ultimate security solution for servers
    ... You should give a price to the first one that succeeds. ... server in the world will be using some variation of my design. ... This is not just my opinion, I have shared this design with my friends ... first thing about business, now that I have a awesome security solution, ...
    (microsoft.public.windows.server.security)
  • Re: So tired of this bug
    ... > I am so so tired of getting this error message when I try to open a web ... > The web server reported the following error when attempting to create ot ... opening one of these projects succeeds. ... Create the file system folderfor the web project ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Why does my MT-NewsWatcher/albasani hiccup so much?
    ... dorayme wrote: ... or posting and this often succeeds at first or second attempt. ... posts every so many mins and just get them manually. ... The other improvement was going back to my isp news server and it ...
    (comp.sys.mac.apps)
  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)