The best way to do data transformation.

Hi,

I have looked through this forum but have not found anything similar.

We want to import certain nds fields into our zenworks asset manager
database. The asset manager database is on a SQL 2000 database.

I have tried to create a data transformation package that queries NDS
and pulls out 7 fields from all users in nds and inserts them into an
SQL table. Then a new process then migrates the data from the temp one
to the assetmanager table.

The process works if I log in tot he server and run it manually but it
will not run if I run it as a scheduled package.

Does any one have some suggestions as to how I am going to do this?

Please keep in mind that I have very little SQL experience and no
programming experience. but am willing to learn. :-)

Thanks

Lance
-- 

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

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