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 |
|
er_stout
Starting Member
3 Posts |
 Posted - 2002-09-25 : 20:02:38
|
| If my question has been addressed elsewhere, please point me to it - otherwise: Trying to take a text file on a local server, convert it into a tmp SQL table using DTS, then cast the tmp table to a static SQL table - On the server, I created two local packages to handle the tasks, and I can run them manually with no errors. BUT - I CANNOT get them scheduled and I don't know why. If I right-click the package and select 'schedule', it gives me that dreaded "Login failed for user '(null)'." When I built the packages, I tried to schedule them internally (using the available 'when does this job execute') but it won't actually execute. Suggestions? I'm using SQL 7.0 and server is running Win98, I believe. |
|
|
er_stout
Starting Member
3 Posts |
Posted - 2002-09-26 : 18:15:34
|
| Well, for any one else trying to resolve this issue: it appears that you can't actually schedule a package from the 'local' repository - you have to store it into one of the other repositories to accomplish the task, and you then have to properly define the owner of the task.BUT- you can go to SQL Agent and create the job (using the proper dtsRun syntax "/S server_name /E [no qual means trusted login] /N package_name) which will default to Local repository and use a trusted connection; and THEN you can actually schedule the Job.What a pain it was figuring that out. |
 |
|
|
rharmon
Starting Member
41 Posts |
Posted - 2002-09-26 : 19:48:04
|
| If you're not recording metadata, it will run much faster through a stored procedure via BCP or linking the directory as a linked server.Just my two "boy I hate DTS cause it's slow" cents worth!ROb |
|
|
|
|
|
|
DTS package scheduling