RE: DTS fails to import data when called from VB6

From: Tim (_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 06:51:04 -0700

Hi There.
I have seen this error before with my colleagues. I don't have the exact
answer, but I think know what the problem is.
Its all about the account that is executing the package. when you save the
DTS package within SQL Server it is saved as the current user. In your case
as its your laotop you have Admin rights. What I ahve seen is that when the
Package is exected, sometimes it is executed under a different account to the
one in SQL. However because you are using VB n your own laptop against the
local server both the application and SQL have full admin rights abd the
package will execute. However when this is on the server this is probably
different. It is either the DTS on the server or the rights and username etc
of your VB app calling the DTS package...or both I hope that steers you a bit
closer
Tim

"Jerome" wrote:

> I have created a DTS package that imports an Access
> database file into a SQL 2000 database. I call this DTS
> package via VB6 and it imports all the data successfully
> on my laptop that contains the MDb file ,VB6 app and the
> local SQL database.
>
> After copying the MDB file to a directory on the server
> (not my laptop), setup the DTS package on the server then
> test the DTS manually it imports the data as well, however
> once I call the server and DTS package via VB6 it does not
> import the data but it does creates the tables?
>
> What is causing it to work on my laptop but fails when run
> with the server connection?
>
> Any Ideas.
>
> Thanks
>
> J
>

Relevant Pages

  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS schedule problem
    ... I found out that the package, sql server agent were running under the SQL ... Who owns the scheduled SQL Agent job? ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... An SSIS package does not run when you call the SSIS package from a SQL ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
Loading