Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Solved
How to trace ssis packages with sql profiler in sql2005
Posted on 2008-06-24
Hi,
Is that possible to trace ssis packages statement with sql2005 profiler, if yes than which event should I pick?
Is that possible to trace ssis packages statement with sql2005 profiler, if yes than which event should I pick?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
6 Comments
Hi,
Please refer to below links to get a clear idea on tracing SSIS....
http://sqlserver-qa.net/blogs/tools/archive/2008/04/09/sql-server-2005-logging-providers-make-best-use-of-ssis-too.aspx
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1248035,00.html
All the best...
Please refer to below links to get a clear idea on tracing SSIS....
http://sqlserver-qa.net/blogs/tools/archive/2008/04/09/sql-server-2005-logging-providers-make-best-use-of-ssis-too.aspx
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1248035,00.html
All the best...
Active today
Hi,
I'm interested with these 2 option but how to create / configure them???
#
SSIS log provider for Text files - the most straightforward option, redirecting entries to a comma-separated value (CSV) text file. In order to review them, you might want to consider importing the content of the file into an Excel (or other application capable of dealing with structured text files).
# SSIS log provider for SQL Profiler - stores logged entries in the format (as a .TRC file) that can be viewed in the SQL Server 2005 Profiler. This gives you the ability to correlate entries generated in response to monitored events with other types of data available via Profiler (such as stored procedure activities, performance or locking-related traces, etc.)
I'm interested with these 2 option but how to create / configure them???
#
SSIS log provider for Text files - the most straightforward option, redirecting entries to a comma-separated value (CSV) text file. In order to review them, you might want to consider importing the content of the file into an Excel (or other application capable of dealing with structured text files).
# SSIS log provider for SQL Profiler - stores logged entries in the format (as a .TRC file) that can be viewed in the SQL Server 2005 Profiler. This gives you the ability to correlate entries generated in response to monitored events with other types of data available via Profiler (such as stored procedure activities, performance or locking-related traces, etc.)
Check the below links for configuring them....
http://msdn.microsoft.com/en-us/library/ms167456.aspx
http://wiki.sqlis.com/default.aspx/SQLISWiki/TextFileLogProviderDynamicLocation.html
http://technet.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/ms167456.aspx
http://wiki.sqlis.com/default.aspx/SQLISWiki/TextFileLogProviderDynamicLocation.html
http://technet.microsoft.com/en-us/library/ms140246.aspx
Active today
It return me as below when I see logging
#Fields: event,computer,operator,so
#Fields: event,computer,operator,so
Featured Post
Ready to get started with anonymous questions today? It's easy! Learn more.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article will describe one method to parse a delimited string into a table of data.
Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month10 days, 22 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.