Receiving this error since migrating to SQL 2000 from SQL 7

Three simple suggestions:
1- Run the DTS package manually and see where (Which step)
you get the error.
2- Create an output file through Package-->Properties--
>Logging in the DTS package and read the output file for
the error.
3- If you upgraded from SQL Server 7.0 to 2000, run
sp_updatestats stored proc for all the databases in the QA.

>--Original Message--
>Ever since migrating to SQL 2000 from SQL 7 I receive
this error at least
>once a day while running jobs through SQL Agent. It may
not be the same job
>having the problem. Any thoughts?
>Executed as user: domain\user. DTSRun: Loading...
Error: -2147467259
>(80004005); Provider Error: 0 (0) Error string:
Timeout expired
>Error source: Microsoft OLE DB Provider for SQL
Server Help file:
> Help context: 0. Process Exit Code 1. The step failed.
>.
>
The job is only failing once or twice a day even though it runs every hour or
in the case of another job, every 1/2 hour. It is never the same time of
day. I can run the DTS job manually and it work without failing. I will
give the logging a try and the sp_updatestats. I didn't upgrade the server -
it was a clean install and a restore from SQL 7. Thanks for your help
"Mark" wrote:

> Three simple suggestions:
> 1- Run the DTS package manually and see where (Which step)
> you get the error.
> 2- Create an output file through Package-->Properties--
> the error.
> 3- If you upgraded from SQL Server 7.0 to 2000, run
> sp_updatestats stored proc for all the databases in the QA.
>
>
> this error at least
> not be the same job
> Error: -2147467259
> Timeout expired
> Server Help file:
>

recbase.cpp:1378 & somerge.c:1616 Errors

Hi,
I am trying to implement a DTS to copy data from one server to another
(both servers are identical), Windows 2000 server and have installed
SQL Server 2000 sp3a.
The DTS in question has the two server connections defined as
"Microsoft OLE DB Provider for SQL Server" and there are several
"Transform Data Tasks" that copy data from tables on one server to
tables on the other. Unfortunately I have to run these steps often as
I am in the process of developing/debugging and I am experiencing one
of the following errors, always when the DTS arrives at the task of
copying the same large table:
Location somerge.c:1616
Expression: mrP->mrStatus!=MERGERUN::NONE
SPID: 78
Process ID: 724
Location recbase.cpp:1378
Expression: m_offBeginVar < m_sizeRec
SPID: 64
Process ID: 840
These errors do not always occur but either one or the other pops up
on a regular basis.
I have run DBCC checkDB and DBCC checktable on the affected Databases
and tables several times and have never found any errors.
Has anyone got any idea of what is causing this? Any suggestions of
what I can do to solve this?
Any help is much appreciated.
Regards
Rekkie
Dear ,
While executing this particular process both servers "sa" passwords should be same,Other wise it never work.
Regards
Faheem Latif
Netsol Pvt Ltd

recbase.cpp:1378 & somerge.c:1616 Errors

Hi,
I am trying to implement a DTS to copy data from one server to another
(both servers are identical), Windows 2000 server and have installed
SQL Server 2000 sp3a.
The DTS in question has the two server connections defined as
"Microsoft OLE DB Provider for SQL Server" and there are several
"Transform Data Tasks" that copy data from tables on one server to
tables on the other. Unfortunately I have to run these steps often as
I am in the process of developing/debugging and I am experiencing one
of the following errors, always when the DTS arrives at the task of
copying the same large table:
Location somerge.c:1616
Expression: mrP->mrStatus!=MERGERUN::NONE
SPID: 78
Process ID: 724
Location recbase.cpp:1378
Expression: m_offBeginVar < m_sizeRec
SPID: 64
Process ID: 840
These errors do not always occur but either one or the other pops up
on a regular basis.
I have run DBCC checkDB and DBCC checktable on the affected Databases
and tables several times and have never found any errors.
Has anyone got any idea of what is causing this' Any suggestions of
what I can do to solve this?
Any help is much appreciated.
Regards
RekkieDear ,
While executing this particular process both servers "sa" passwords should b
e same,Other wise it never work.
Regards
Faheem Latif
Netsol Pvt Ltd|||Both passwords are the same. I don't see however what has
to do with the problem as each OLEDB server connection is
defined separately with the user to use for that
connection.

>--Original Message--
>Dear ,
>While executing this particular process both servers "sa"
passwords should be same,Other wise it never work.
>Regards
>Faheem Latif
>Netsol Pvt Ltd
>.
>

Rebuild dependancy Information

Is it possible to rebuild dependancy information for objects in a database?

I can hardly ever DTS a database across to another server because
something will fail with the message "invalid object name
<name_of_a_view>". This happend to me just now on a database with just
12 tables and 4 views. What hope for my other databases with 100s of views?(Reposted question)

> Is it possible to rebuild dependancy information for objects in a database?
> I can hardly ever DTS a database across to another server because
> something will fail with the message "invalid object name
> <name_of_a_view>". This happend to me just now on a database with just
> 12 tables and 4 views. What hope for my other databases with 100s of views?|||"Trev@.Work" <no.email@.please> wrote in message
news:4027c1b2$0$28848$afc38c87@.news.easynet.co.uk. ..
> (Reposted question)
> > Is it possible to rebuild dependancy information for objects in a
database?
> > I can hardly ever DTS a database across to another server because
> > something will fail with the message "invalid object name
> > <name_of_a_view>". This happend to me just now on a database with just
> > 12 tables and 4 views. What hope for my other databases with 100s of
views?

Can you be more specific about what is happening when the error occurs? At
first glance, it doesn't seem like a dependency issue, but rather that the
view doesn't exist. Are you using the DTS Copy Database task? I'm not 100%
sure, but I believe it detaches, copies and attaches the database, so
missing objects should be unlikely.

Also, if you always copy the entire database, you might want to consider
backup/restore instead of DTS.

Simon|||Simon Hayes wrote:

> "Trev@.Work" <no.email@.please> wrote in message
> news:4027c1b2$0$28848$afc38c87@.news.easynet.co.uk. ..
>>(Reposted question)
>>
>>
>>>Is it possible to rebuild dependancy information for objects in a
> database?
>>>I can hardly ever DTS a database across to another server because
>>>something will fail with the message "invalid object name
>>><name_of_a_view>". This happend to me just now on a database with just
>>>12 tables and 4 views. What hope for my other databases with 100s of
> views?
> Can you be more specific about what is happening when the error occurs? At
> first glance, it doesn't seem like a dependency issue, but rather that the
> view doesn't exist.

The view exists, definately.

Are you using the DTS Copy Database task? I'm not 100%
> sure, but I believe it detaches, copies and attaches the database, so
> missing objects should be unlikely.

From EM, export data... Copy objects and data between SQL Server databases.

> Also, if you always copy the entire database, you might want to consider
> backup/restore instead of DTS.

That's what I have to resort to usually. I would like to achieve the
same result with one step if possible.|||"Trev@.Work" <no.email@.please> wrote in message
news:4028d626$0$29822$afc38c87@.news.easynet.co.uk. ..
> Simon Hayes wrote:
> > "Trev@.Work" <no.email@.please> wrote in message
> > news:4027c1b2$0$28848$afc38c87@.news.easynet.co.uk. ..
> >>(Reposted question)
> >>
> >>
> >>>Is it possible to rebuild dependancy information for objects in a
> > database?
> >>>I can hardly ever DTS a database across to another server because
> >>>something will fail with the message "invalid object name
> >>><name_of_a_view>". This happend to me just now on a database with just
> >>>12 tables and 4 views. What hope for my other databases with 100s of
> > views?
> > Can you be more specific about what is happening when the error occurs?
At
> > first glance, it doesn't seem like a dependency issue, but rather that
the
> > view doesn't exist.
> The view exists, definately.
> Are you using the DTS Copy Database task? I'm not 100%
> > sure, but I believe it detaches, copies and attaches the database, so
> > missing objects should be unlikely.
> From EM, export data... Copy objects and data between SQL Server
databases.
> > Also, if you always copy the entire database, you might want to consider
> > backup/restore instead of DTS.
> That's what I have to resort to usually. I would like to achieve the
> same result with one step if possible.

Have you applied the latest servicepack? There are a number of KB articles
which may describe this:

http://support.microsoft.com/defaul...kb;en-us;291780
http://support.microsoft.com/defaul...kb;en-us;281664
http://support.microsoft.com/defaul...kb;en-us;300272

Simon

re-arrange name data

i'm attempting to make a DTS package that will export to a csv each day. my problem is figuring out how to change a name field that stores the data as the following format:

First Middle Last

into

Last, First Middle in the outputted .csv file

thanks in advance.

-csubstring(fld,len(fld) - charindex(' ',reverse(fld)),len(fld))
+ ', ' + left(fld,len(fld)-charindex(' ',reverse(fld)))

The numbers will be a bit wrong but you can fix that.

really appreciated.

Is it possible through front end like I can call DTS package on demand like
on button click.. for instance on button PUSH click I want to call Package1
and on button PULL click I want to call Package2... how can it be possible?
any help is available ?
I would really appreciate....
Thanks
Try SQLDTS.com. There you will find examples of invoking DTS packages from
VB, ASP, .NET languages etc.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Roy" <roy@.hotmail.com> wrote in message
news:%23n3rRKWcFHA.1448@.TK2MSFTNGP14.phx.gbl...
Is it possible through front end like I can call DTS package on demand like
on button click.. for instance on button PUSH click I want to call Package1
and on button PULL click I want to call Package2... how can it be possible?
any help is available ?
I would really appreciate....
Thanks

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciated
My personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/boo...sbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciatedMy personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/bo...isbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>