"Allan Mitchell" wrote:
> 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@dbForumz.com> wrote in message
> news:4_800499_515be0fdcf32abd568c489b50c09755d@dbforumz.com...
> > 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:tempdtsrun /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-hangs-complete-ftopict231215.html
> > Visit Topic URL to contact author (reg. req'd). Report
> abuse:
> > http://www.dbforumz.com/eform.php?p=800499

"ryoko" <UseLinkToEmail@dbForumz.com> wrote in message
news:4_800499_515be0fdcf32abd568c489b50c09755d@dbforumz.com...
> 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-hangs-complete-ftopict231215.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=800499