Log of rows inserted/updated/deleted

HI, I am wondering if it is possible to retreive this information without using row count transform. Can I get the # of rows inserted/updated or deleted by destination from the log?

Thank you,
Ccote

An OnInformation event is raised by the data-flow task when data flows into a destination. This has free text which contains the number of rows. You would have to parse that information out of the text within the OnInformation eventhandler. See here for more details: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=372847&SiteID=1

-Jamie

Log file with header row only.

I have a parent a package which contains a bunch of Execute Package tasks. The parent package sets a variable which contains the directory for writing logs to. Each child is configured to write logs to a text file, and uses a connection manager for doing so. The connection manager uses an expression for setting the connection string, and in this expression the log directory varaible is used (e.g. @.[User::LogDir] + "\\FileName.log").

Now the problem is this, when I run the ETL, I'm getting 2 set of log files for each package: one log file is created in C:\ and the other in the correct dirctory. Each log in C:\ just contains a single header row, and the corresponding log file in the logging dir contains the log data (including the header row). Even though the filename is specified in an expression, a value for the connection string appears in the properties for the connection manager ("\Filename" which probably where the C:\ log files are coming from). I can't seem to remove this value, and I don't want to hard-code it to a fixed path. I've also set DelayValidation to True, with no luck. I feel I must be missing something obvious, any suggestions? Thanks!

Fraser,

Interesting problem. You might get something from reading through this:

Logging With SSIS: Beware of Parent Package Variable configuration!

I've made a few comments here:

SSIS: Package spin-up order of events

(http://blogs.conchango.com/jamiethomson/archive/2006/10/08/SSIS_3A00_-Package-spin_2D00_up-order-of-events.aspx)

-Jamie

|||

Thanks for the info Jamie. I'm going to give this work-around a try: create a new parent package which is nothing more than a wrapper - it has a script task that creates an environment variable (set to the contents of log directory variable), and then uses an execute package task to start the real parent package. Then each package including the real parent package can pull this directory from the environment variable rather than from a parent variable. This way setting up the environment variable is hidden from the end user and all configuration will be localized to a single config file.

log deleted row

Is it possible to find who was deleted row from sql server 2000 with t-sql,
query analyzer?
If you haven't logged this yourself (using, for instance triggers), your only hope would be to use a
3rd party tool to explore the transaction log. This requires the log records to still exists in the
transaction log. I've listed some such tools at http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nikolami" <nikolami@.nyc.com> wrote in message news:dv3qck$493$1@.ss405.t-com.hr...
> Is it possible to find who was deleted row from sql server 2000 with t-sql,
> query analyzer?
>

log deleted row

Is it possible to find who was deleted row from sql server 2000 with t-sql,
query analyzer?If you haven't logged this yourself (using, for instance triggers), your only hope would be to use a
3rd party tool to explore the transaction log. This requires the log records to still exists in the
transaction log. I've listed some such tools at http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nikolami" <nikolami@.nyc.com> wrote in message news:dv3qck$493$1@.ss405.t-com.hr...
> Is it possible to find who was deleted row from sql server 2000 with t-sql,
> query analyzer?
>

log deleted row

Is it possible to find who was deleted row from sql server 2000 with t-sql,
query analyzer?If you haven't logged this yourself (using, for instance triggers), your onl
y hope would be to use a
3rd party tool to explore the transaction log. This requires the log records
to still exists in the
transaction log. I've listed some such tools at http://www.karaszi.com/SQLServer/l
inks.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nikolami" <nikolami@.nyc.com> wrote in message news:dv3qck$493$1@.ss405.t-com.hr...green">
> Is it possible to find who was deleted row from sql server 2000 with t-sql
,
> query analyzer?
>

Locks in SQL2000

How to lock a Row in SQL2000 so that nobody can select that row.

I applied ROWLOCK, but i am not finding the way.

My query is"SELECT * FROM tablename WITH (ROWLOCK)"

Is this the correct way to write locks.

I would be thankful if u help me

Hi,

Maybe the following link is helpful to you.

Row-Level Locking Using ADO & SQL Server http://support.microsoft.com/kb/252317

Thanks.

|||

Hi all,

I am using SQLServer 2000 & .Net 2003 (1.1 framework)

I had a database calledDATA and the fields ID, Name, Remarks, etc...

I need to give access all the data to my employees in their browser machines.

Number of employees may be from 50 to 150.

If a particular record is fetched by 2 users simultaneously one person is getting an error. For this i need to put locks in the database.

If a particular record is fetched by 1 user, then immediately the another employee who is accessing it, should get another record/data.

Being keeping in mind, how can i solve this scnario?

Any body please help me...

Regards,

Jai Shankar