I have setup an integration manager DSN and have configured it with a sql login and password in order to use the Direct to table import. I then configure the destination settings on the integration itself as well. Everytime we run it or open it, it prompts for a sql dsn login information. I have already entered this in the DSN as well as the destination settings. Why does it prompt again? We don't want our users to have to enter this in and this would cause problems if we wanted these scheduled.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Direct to table integration prompting login info
- Thread starter Luvsql
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question