Solved

How to trace ssis packages with sql profiler in sql2005

Posted on 2008-06-24

Microsoft SQL Server 2005

2 solutions

1,835 Views

Last Modified: 2010-05-18

Hi,
Is that possible to trace ssis packages statement with sql2005 profiler, if yes than which event should I pick?

Comment

Question by:motioneye

[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

Join The Community

6 Comments

LVL 14

Accepted Solution

by:Jagdish Devaku

Jagdish Devaku earned 500 total points

ID: 218536192008-06-24

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...

Author Comment

by:motioneye

ID: 218537042008-06-24

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.)

LVL 14

Assisted Solution

by:Jagdish Devaku

Jagdish Devaku earned 500 total points

ID: 218537342008-06-24

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

Author Comment

by:motioneye

ID: 218621642008-06-24

It return me as below when I see logging

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

LVL 14

Expert Comment

by:Jagdish Devaku

ID: 218628712008-06-24

does it showing log information also...?

Author Comment

by:motioneye

ID: 218630132008-06-24

Hi that what it written in log file, Just curious what is wrong then?

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read Excel data from SQL Server 2005

Article by: pankaj_3425

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…

Microsoft SQL Server 2005

Running queries on remote databases from SQL Server

Article by: Guy

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…

Microsoft SQL Server 2005

How to see a live map of your network in NetCrunch network monitor

Video by: AdRem

In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

Bar Graphs in an Access Query

Video by: crystal

Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …