Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JonahMk2
Starting Member
21 Posts |
 Posted - 2004-10-27 : 06:40:50
|
| I have set up an Import DTS to extract data from an AS400. You need to sign on when accessing the AS400 data. I want to schedule the DTS Package to extract the data every morning. I have tested this but it does not work. I think it is because of the sign-on. Any ideas on how to get around this?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 13:03:09
|
| What is the error?Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-27 : 22:18:34
|
quote:
Originally posted by JonahMk2
I have set up an Import DTS to extract data from an AS400. You need to sign on when accessing the AS400 data. I want to schedule the DTS Package to extract the data every morning. I have tested this but it does not work. I think it is because of the sign-on. Any ideas on how to get around this?Thanks
hmm.. don't you need to setup a dsn for that in your odbc source administrator? then use that driver in your import dts.--------------------keeping it simple... |
|
|
|
|
|
|
Sign-On