Hi,

I created a simple DTS package to export data of some tables to Excel
file. I want to execute it with dtsrun.exe but it hangs before
complete.

The message is like these( I’m using SQLServer Japanese version so I
translated the output. maybe it is not exact)

C:\temp\dtsrun /FMyDTS.dts /NMyPackage
DTSRun: loading...
DTSRun: executing...
DTSRun OnStart: Create table TABLE1 step
DTSRun OnStart: Create table TABLE2 step
DTSRun OnStart: Create table TABLE3 step
DTSRun OnFinish: Create table TABLE1 step
DTSRun OnStart: Copy Data from TABLE1 to TABLE1 step

After "Copy Data from TABLE1 to TABLE1 step" it hangs.
Searching on internet I found an article on MSkb.

http://support.microsoft.com/kb/290077/en-us

The article saids it is a known issue and fixed by SQL Server 2000
Service Pack 1.
So I downloaded and installed the database component
module(JPN_SQL2KSP3.exe) of Service Pack 3a which includes SP1 update.

But the same problem still happens. It happends also with dtsrunui.exe
or on Enterprise Manager. I searched on this site with key words like
"not complete","hangs","stops" but I found no proper result.


If somebody knows this problem please help me!

thank you,
Ryoko

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/DTS-run.exe-...ict231215.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=800499

Where did you install the update? Remember DTS is a client side app and
there fore it would need to be whereever the package is executing.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ryoko" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote

"Allan Mitchell" wrote:
Thank you for your response.

I use both server and client on the same machine.
I checked if update was executed successfully with a query "SELECT
@@VERSION" which returns "Microsoft SQL Server 2000 - 8.00.760".
So I think my SQLServer is updated by SP3/SP3a.

Anyway trying some options on DTS package I found that if I select
"Register log on package execution" on Log tab page in DTS Package
Property with "Use SQLServer authentication" radiobutton the package
is executed properly.
It seems so strange but I executed some packages with above options
several times and all go well.

Now I want to execute the package by DTS client on which no SP is yet
adapted.