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 |
|
sschwarze
Starting Member
15 Posts |
 Posted - 2003-10-22 : 11:24:04
|
| I am looking for a way to gove logging back to an user that is not in the enterprise manager. ie run a dts package and see the results. Where are the logs kept? Can you view them interactivly? Is there a way to display the process of the job while it is running like in enterprise manager? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 12:19:26
|
| Logging is stored in SQL Server if you turn it on. To turn it go, go to your package properties, then to logging. There is an error handling section also on that tab.Tara |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-10-22 : 12:41:40
|
| Alternatively, you could also specify a text log file, from the location Tara mentioned.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 12:47:12
|
| When a text log file is specified, are you able to see the info while the DTS package is running? I guess it would depend on when the logging saves the info to the file.Tara |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-10-22 : 13:04:09
|
quote:
Originally posted by tduggan
When a text log file is specified, are you able to see the info while the DTS package is running?
Text log file is created only at the end of the DTS package execution.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-22 : 13:13:37
|
| Vyas, do you know if logging the info to SQL Server will allow Scott (well Scott's user) to view the info while the DTS package is running?Scott, when you say that your user isn't in EM, do you mean that the user has no access to that SQL Server or just doesn't having the SQL client tools installed? If it's the first, then you could write a very small app that would read the table or could you add the user to SQL Server and grant SELECT on this table. If the SQL client tools aren't installed, then the user will not be able to see the info without an application doing it for him/her. I believe that the info will get written to sysdtspackagelog in the msdb database.Tara |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-10-23 : 12:58:41
|
| Tara, yes it does look like DTS is writing status messages to msdb..sysdtssteplog as it is executing the steps.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
|
|
DTS Logging