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 |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2002-04-04 : 11:59:03
|
| I'm having major problems with a DTS that I created a few days ago. I have 7 different processes to run inside the DTS:The first is to execute a batch file. (this works)The second is to export data from a DBIII file to a table on the SQL server. This will NOT retain the password that I type in so it fails. We never get to the following steps because step 2 is failing.I created this DTS on my pc using the sa logon and password. This process is run on another pc that has owner rights and permissions.Does anyone have any ideas? I am clueless at this point!Thanks!TeresaBoth pcs have SQL server 7.0 SP3"Someday I'll know enough to help someone else!"Edited by - tj on 04/04/2002 12:01:56 |
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2002-04-04 : 13:47:46
|
| Has anyone heard of SP3 wiping out the fixes that were distributed with SP2? It appears that the error I'm getting was bug # 56660. It's reappeared since we installed the latest service pack.Thanks again!"Someday I'll know enough to help someone else!" |
 |
|
|
|
|
|
DTS Password Problem