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 - 2002-09-27 : 08:34:30
|
| Eric writes "SQL 7.0, Win 98. I am trying to automate a data import process (and yes, I read the article of the same name). I set up two DTS packages - one which grabs a .txt file and imports it into a temporary char sql table, the second takes the tmp table and casts it via T-SQL into my destination table. I used [local server] for both packages, but when I try to [schedule] either one, I get a message "Invalid user '(null)' for trusted connection".Either I've built my DTS packages incorrectly, or when executing as an ODB job, they are being forced to run as though not on the local server and therefore can't connect. Any suggestions?" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-08 : 12:58:57
|
| THe schedualer uses SQL Server Agent. You need to ensure it's running and under a valid account with valid permissions.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
DTS issue with invalid user 'Null'