Error running DTS script in VB

[David Greenberg]

Hi

We use SqlServer 2000.
We saved a DTS package as a VB file. The DTS copies data from an Ingres
table (on a VMS server) to a table in Sql Server.
When the actual DTS is run from Enterprise the packages executes fine.
We tried to run the module in VB and received an error:
"Unable to authenticate Client's user id" despite the fact that the DSN
test to the Ingres server was successfull.
We tried defining the server name as an Ingres user but that didn't help.

Anyone have any idea what the problem could be ?

Thanks

David Greenberg

[rshivaraman]

I am not sure if this will help, but we call a stored proc usp_xxx
from .net, which in turn calls the dts
---
CREATE PROCEDURE dbo.usp_xx
@prm_Server varchar(255),
@prm_PkgName varchar(255),
@prm_ServerUID varchar(255),
@prm_ServerPWD varchar(255)
AS

SET NOCOUNT ON

--
-- Return Values:
-- 0 - success
-- 1 - failed to add record to parm table

exec spExecutePKG
@prm_Server,@prm_PkgName,@prm_ServerUID,@prm_Serve rPWD,''

RETURN 0
GO
---