HI,
I would like to make a readable log file of all transactions that have
been done by my DTS ..


Thanks

What do you mean by a readable log?

You can use a Post Process step to write out what happened in your package

SQL Server will do a lot of this for you if you choose to log to SQL Server
in the sysDTS*log table


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"mtl_jf" <jf_lanouette (AT) hotmail (DOT) com> wrote

Thanks Allan,

I saw in those table that you can see the steps that the package did
but i didn't see anything about...

INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_1,
VALUES_1,VALUES_1 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_2,
VALUES_2,VALUES_2 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_3,
VALUES_3,VALUES_3 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_4,
VALUES_4,VALUES_4 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_5,
VALUES_5,VALUES_5 )
UPDATE TABLE SET FIELDS = VALUES_6
....

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Thanks Allan,

I saw in those table that you can see the steps that the package did
but i didn't see anything about...

INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_1,
VALUES_1,VALUES_1 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_2,
VALUES_2,VALUES_2 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_3,
VALUES_3,VALUES_3 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_4,
VALUES_4,VALUES_4 )
INSERT INTO TABLE (FIELDS, FIELDS, FIELDS) VALUES (VALUES_5,
VALUES_5,VALUES_5 )
UPDATE TABLE SET FIELDS = VALUES_6


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nobody have any idea on this ??

In message <uFuun9sfEHA.3476 (AT) tk2msftngp13 (DOT) phx.gbl>, Jean-Francois
Lanouette <jf_lanouette (AT) hotmail (DOT) cmo> writes
There is no logging like this at all. It would seem a bit strange for me
to import a text file, to have another file produced of what I
imported!!
So I question why this would make sense exactly. Wouldn't a better
mechanism be to track rows as they are inserted so that you know where
they came from? Depends on what you really need this for.

Another alternative may be a product such as Lumigent Log Explorer or
Entegra that can track stuff via the SQL transaction log.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org