Using DTS for MAS90 import

[JBG]

Hello SQL Server experts,

This is round 2 of my SQL server newbie questions.

I am trying to run a nightly DTS job to import 5 tables from MAS90 into my SQL 2000 database. Thanks to the last tek-tip expert, I have secured a connections string (DSN=SOTAMAS90;UID=XXX|YYY;PWD = ZZZZZZZ;COMPANY=YYY;Directory=\\....), but I do not know where to insert this (that is, into what wizard) so that I dont get the MAS90 popup each time SQL Server tries to access MAS90.

I have the Microsoft SQL Server 2000 Administrator's Pocket Consultant (great reference) and have scoured the DTS section. But I still am at a loss as to how to proceed.

Summary:

I need (want) to use DTS to import/refresh 5 MAS90 tables each night (a scheduled job). But the MAS90 popup rears its ugly head everytime someone knocks on its door.

How do I get around this in DTS? If it cant be done in DTS, how can it be done within SQL Server 2000? Script? Where? How? I have never written one before

Thanks for any insight into this. I am desperate.

JBG

 

[JBG]

I found out the answer.

the MAS90 dsn (admin tools, etc) allows you to enter the company, uid and pw. It was too easy, and it worked.

We just edited the existing machine dsn, and voila!

JBG