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 |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-08-30 : 16:37:06
|
| Greetings,My goal is to log the execution of a package using SQL Profiler Logging ProviderThe package executes without errors but no events are getting captured or at least the created log file cannot be found.Also, can someone shine some light of the above book excerpt, please.What is meant by: "SAMPLES:WORKINGFOLDER" ThanksExcerpt out of Microsoft SQL Server 2005 Integration Services By Kirk HaseldenThe log providers use connection managers to determine where to create the logs. The connection managers each havean expression to build the ConnectionString and point to the temporary working folder. Look at theSAMPLES::WORKINGFOLDER variable to find where the package creates the log files. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-30 : 17:09:27
|
Looks like a variable that holds the foldername.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-08-30 : 18:30:47
|
| but is this variable a) system variable or b) user variableif a): where can it be accessedif b): how is it referencing the connection managerdo you have experience using SQL Profiler Log Provider?thanks |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-31 : 06:06:03
|
| It's a User Variablea) It can be accessed within the scope of its declaration (e.g. package, container)b) The variable is referenced in the connection manager. Right-click on the log connection manager, get the properties. Look in the expressions. It will most likely be used there.Yes. I use logging for all my packages - create a package template. |
|
|
|
|
|
|
Locating file destination for SQL Profiler Lo