The best way to do data transformation.

Hi Susan,

Thanks for responding.

No I am not using VB I just wanted to create a package in
the SQL
enterprise manager that transforms data.

looks like I will have to do things manually 

Thanks anyway

Lance

-- 



Susan Perrin wrote:

> Hi
> 
> Are you logged in when running as a scheduled package? 
If not,
> you'll want to.  The odbcnds driver uses the current
client login
> state, and doesn't provide a mechanism to
authenticate.
> 
> Are you using VB?  If so, there are some activex
controls at
> developer.novell.com/ndk/activex_ndap.htm which allow
you to do a
> login.  See nwdir.login.
> 
> Thank you
> Susan