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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-01 : 11:03:12
|
| Amy writes "I have problems creating jobs that use DTS packages. Specifically, the packages that are talking to our AS/400. I have succeeded in creating these jobs and scheduling them, but now we're faced with getting one of these DTS packages to execute from an ASP page. The reason that I mentioned the job setup, is because I had a lot of the same problems as the ASP pages. I can get it to run, but it only drops and creates the table. I need it to complete the package and actually copy the data over. Do you have any information regarding the best way to set up authentication between the AS/400 and the SQL server? I currently am using NT authentication in the DSN and in the package setup itself. I have it set up so that it is not prompting for a username on the AS/400 side, but I still think I must be missing something. I hope this is clear for you. If you have any info regarding any portion of this, I would greatly appreciate it!" |
|
|
Nazim
A custom title
1408 Posts |
|
|
Nazim
A custom title
1408 Posts |
|
|
|
|
|
|
|
Using DTS in ASP and scheduling jobs 