MAS90 and SQL Server/DTS - help! 2

[JBG]

I am new to using DTS and SQL Server 2000. I need to schedule a nightly import from MAS90 into my SQL 2K backend. However, anytime MAS90 is accessed, the login/pw screen comes up. So, while creating a DTS scheduled job is easy, I cant get around the dang login popup.

I need a way around this so that the job can run at night(automated).

I have just about no idea how to proceed. Is there a script that can be written that can inlcude the pw, login, etc? If so, any samples? How would I lunch such a script? Form within SQL, or from , say, VB6?

Any info would be greatly appreciated.

JBG

 

[philhege]

Read this post:

http://groups.google.com/groups?hl=.../groups?q=MAS90+login&ie=UTF-8&oe=UTF-8&hl=en

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

 

[JBG]

Much obliged for the bullseye link and quick response.

Now, can a script/procedure be created inside of SQL Server to launch the nightly import???

Jeff

 

[mas90guru]

You might take a look here as well. Some good VI and general tips and tricks information.

http://slade.pvxhost.com/tricks.phtml

Regards,

Wayne Schulz

Schulz Consulting, LLC

http://www.s-consult.com

 

[JBG]

Thank you. I appreciate the link....


Jeff