Hi,

I'm running a DTS from a scheduled job and it's taking ages. The DTS transfers data between 2 tables and I would like to see how far the DTS has gone -use fast load is enabled-. I can see from running sp_who2 that data is being inserted into the destination table via a bulk insert, which makes me think that the data has been transfered from the source table to a file then from that file to the destination table. Does anybody know where that staging file will be found?

Cheers

BULK INSERT or INSERT BULK.

insert bulk [tempdb].[dbo].[authors]("au_id" varchar(11) COLLATE
Latin1_General_CI_AS,"au_lname" varchar(40) COLLATE
Latin1_General_CI_AS,"au_fname" varchar(20) COLLATE
Latin1_General_CI_AS,"phone" char(12) COLLATE Latin1_General_CI_AS,"address"
varchar(40) COLLATE Latin1_General_CI_AS,"city" varchar(20) COLLATE
Latin1_General_CI_AS,"state" char(2) COLLATE Latin1_General_CI_AS,"zip"
char(5) COLLATE Latin1_General_CI_AS,"contract" bit,"XXX" char(10) COLLATE
Latin1_General_CI_AS)with(check_constraints)

If the latter then I believe this is simply the call from
SQLOLED::IRowsetFastLoad

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ole
dbsql.chm::/9_ole_08_0prn.htm

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Elisabeth" <lise_bisou (AT) hotmail (DOT) com> wrote

gone -use fast load is enabled-. I can see from running sp_who2 that data is
being inserted into the destination table via a bulk insert, which makes me
think that the data has been transfered from the source table to a file then
from that file to the destination table. Does anybody know where that
staging file will be found?