DTSRun doesn't complete

From a cmd prompt I am trying to DTS data out of an old version of
Btrieve to SQL Server 2000. It does the work just fine.
The last thing it displays is
DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
Step
However, at this point it just sits there and never comes back to the
command prompt.
Anyone know what may be wrong?John.Wentworth@.emersonprocess.com (JohnW) wrote in message news:<5d096b4e.0312300929.42ac5776@.posting.google.com>...
> From a cmd prompt I am trying to DTS data out of an old version of
> Btrieve to SQL Server 2000. It does the work just fine.
> The last thing it displays is
> DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
> Step
> However, at this point it just sits there and never comes back to the
> command prompt.
> Anyone know what may be wrong?
Nevermind I figured it out|||Wat was the reason for it not to come back to cmdprompt ?
jobi
"JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
news:5d096b4e.0312301428.348e1a2f@.posting.google.com...
> John.Wentworth@.emersonprocess.com (JohnW) wrote in message
news:<5d096b4e.0312300929.42ac5776@.posting.google.com>...
> > From a cmd prompt I am trying to DTS data out of an old version of
> > Btrieve to SQL Server 2000. It does the work just fine.
> >
> > The last thing it displays is
> >
> > DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
> > Step
> >
> > However, at this point it just sits there and never comes back to the
> > command prompt.
> >
> > Anyone know what may be wrong?
> Nevermind I figured it out|||"jobi" <jobi@.reply2.group> wrote in message news:<bstuqh$rte$1@.reader08.wxs.nl>...
> Wat was the reason for it not to come back to cmdprompt ?
Well for some reason you have specifically set the "Close Connection
on Completion" switch. This is found in the Workflow Properties
screen, Options tab. As soon as I set this the DTS package finishes
just like it should and comes back to the command prompt.
I am trying to DTS an entire database consisting of 198 tables. I have
to go to each connection and set this. They don't give you a way to
set this across the entire package. What a pain in the ass!
> jobi
> "JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
> news:5d096b4e.0312301428.348e1a2f@.posting.google.com...
> > John.Wentworth@.emersonprocess.com (JohnW) wrote in message
> news:<5d096b4e.0312300929.42ac5776@.posting.google.com>...
> > > From a cmd prompt I am trying to DTS data out of an old version of
> > > Btrieve to SQL Server 2000. It does the work just fine.
> > >
> > > The last thing it displays is
> > >
> > > DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
> > > Step
> > >
> > > However, at this point it just sits there and never comes back to the
> > > command prompt.
> > >
> > > Anyone know what may be wrong?
> >
> > Nevermind I figured it out|||So do it using the object model.
Function Main()
dim tsk
dim stp
dim pkg
dim cusTask
dim prp
set pkg = DTSGlobalVariables.Parent
for each tsk in pkg.Tasks
if tsk.CustomTaskID = "DTSDataPumpTask" THEN
for each stp in pkg.steps
if stp.TaskName = tsk.Name then
stp.Properties("CloseConnection").Value = -1
end if
Next
End if
Next
Main = DTSTaskExecResult_Success
End Function
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
"JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
news:5d096b4e.0312310501.9624dee@.posting.google.com...
> "jobi" <jobi@.reply2.group> wrote in message
news:<bstuqh$rte$1@.reader08.wxs.nl>...
> > Wat was the reason for it not to come back to cmdprompt ?
> Well for some reason you have specifically set the "Close Connection
> on Completion" switch. This is found in the Workflow Properties
> screen, Options tab. As soon as I set this the DTS package finishes
> just like it should and comes back to the command prompt.
> I am trying to DTS an entire database consisting of 198 tables. I have
> to go to each connection and set this. They don't give you a way to
> set this across the entire package. What a pain in the ass!
>
>
> >
> > jobi
> > "JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
> > news:5d096b4e.0312301428.348e1a2f@.posting.google.com...
> > > John.Wentworth@.emersonprocess.com (JohnW) wrote in message
> > news:<5d096b4e.0312300929.42ac5776@.posting.google.com>...
> > > > From a cmd prompt I am trying to DTS data out of an old version of
> > > > Btrieve to SQL Server 2000. It does the work just fine.
> > > >
> > > > The last thing it displays is
> > > >
> > > > DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
> > > > Step
> > > >
> > > > However, at this point it just sits there and never comes back to
the
> > > > command prompt.
> > > >
> > > > Anyone know what may be wrong?
> > >
> > > Nevermind I figured it out|||thanks for the feedback.
Happy newyear.
"JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
news:5d096b4e.0312310501.9624dee@.posting.google.com...
> "jobi" <jobi@.reply2.group> wrote in message
news:<bstuqh$rte$1@.reader08.wxs.nl>...
> > Wat was the reason for it not to come back to cmdprompt ?
> Well for some reason you have specifically set the "Close Connection
> on Completion" switch. This is found in the Workflow Properties
> screen, Options tab. As soon as I set this the DTS package finishes
> just like it should and comes back to the command prompt.
> I am trying to DTS an entire database consisting of 198 tables. I have
> to go to each connection and set this. They don't give you a way to
> set this across the entire package. What a pain in the ass!
>
>
> >
> > jobi
> > "JohnW" <John.Wentworth@.emersonprocess.com> wrote in message
> > news:5d096b4e.0312301428.348e1a2f@.posting.google.com...
> > > John.Wentworth@.emersonprocess.com (JohnW) wrote in message
> > news:<5d096b4e.0312300929.42ac5776@.posting.google.com>...
> > > > From a cmd prompt I am trying to DTS data out of an old version of
> > > > Btrieve to SQL Server 2000. It does the work just fine.
> > > >
> > > > The last thing it displays is
> > > >
> > > > DTSRun OnFinish: Copy Data from Account to [Test123].[dbo].[Account]
> > > > Step
> > > >
> > > > However, at this point it just sits there and never comes back to
the
> > > > command prompt.
> > > >
> > > > Anyone know what may be wrong?
> > >
> > > Nevermind I figured it out

dts to copy jobs

We are upgrading our SQL 2000 Enterprise Server to a new server running the
same. When using DTS to transfer the jobs from old server to new 4 of them
will not transfer over to the new server. It just gives a unspecified error.
Any ideas?
You can generate a script for the jobs instead, through Enterprise Manager
(right click a job name, and it is under Tasks). Just run the generated
script on the target server.
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Tom Reis" wrote:

> We are upgrading our SQL 2000 Enterprise Server to a new server running the
> same. When using DTS to transfer the jobs from old server to new 4 of them
> will not transfer over to the new server. It just gives a unspecified error.
> Any ideas?
>
>

dts to copy jobs

We are upgrading our SQL 2000 Enterprise Server to a new server running the
same. When using DTS to transfer the jobs from old server to new 4 of them
will not transfer over to the new server. It just gives a unspecified error.
Any ideas?You can generate a script for the jobs instead, through Enterprise Manager
(right click a job name, and it is under Tasks). Just run the generated
script on the target server.
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Tom Reis" wrote:

> We are upgrading our SQL 2000 Enterprise Server to a new server running th
e
> same. When using DTS to transfer the jobs from old server to new 4 of them
> will not transfer over to the new server. It just gives a unspecified erro
r.
> Any ideas?
>
>

dts to copy jobs

We are upgrading our SQL 2000 Enterprise Server to a new server running the
same. When using DTS to transfer the jobs from old server to new 4 of them
will not transfer over to the new server. It just gives a unspecified error.
Any ideas?You can generate a script for the jobs instead, through Enterprise Manager
(right click a job name, and it is under Tasks). Just run the generated
script on the target server.
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Tom Reis" wrote:
> We are upgrading our SQL 2000 Enterprise Server to a new server running the
> same. When using DTS to transfer the jobs from old server to new 4 of them
> will not transfer over to the new server. It just gives a unspecified error.
> Any ideas?
>
>