I'm trying to gather information from within a SSIS package for benchmarking, reconciliation, and reporting purposes in regards to cube processing, which I'm initiating using the AS processing task.
What is the easiest way to capture this information
The only way I've been able to come up with is to use a profiler trace. If this is really the only way, what is the easiest way to execute and read the trace from within SSIS
Also, if a script task has to be used, does anyone have a code sample
Thanks in advance!
Easiest way to start and read a trace from within a SSIS package
Hot Topic
- Configurations
- Running SQL Server Enterprise 2005 on MS Virtual Server
- Problem installing sql 2005 express ---cannot start service etc.... :(
- Couldn't make Filter Option of Report to work
- Dynamic T-SQL steatment
- Show Message if dataset is Empty
- A view based on a parameter
- How can i generate a cube of XML Data
- Number of User Databases
- SSAS service does not start
SQL Server
- Migrating form access to SQL
- Formatting T-SQL Performacne Boost?????
- I am practicing by building a PM Online App
- is this possible in SSIS?
- Custom Assembly generates error in Aggregation Wizard
- Moving sql 2000 DTS packages to sql 2005 standard edition
- rsInvalidItemPath error SQL Server 2005 Reports
- Need to create <Query> statement programmatically
- problem with microsoft xp....help please
- How Is This Technology deployed?
Easiest way to start and read a trace from within a SSIS package
Jimmyusa
Thanks again.
ybkang
Simplest way is to read the trace into SQL server. You can use the fn_trace_gettable to either populate a new table or return the data to SSIS by using an OLEDB source
see BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c2590159-6ec5-4510-81ab-e935cc4216cd.htm