Another problem with "Transfer SQL Server Objects Task"

Hi everyone,

I'm currently having some trouble with the "Transfer SQL Server Objects Task".
All I wanna do is to copy a simple database from one server (SQL2000) to another one (SQL2005).

A small excerpt from my settings:

DropObjectsFirst: true
ExistingData: Replace
All table options are set to true
.
No matter what I do the package always appends the data from the source to the destination database.

Is this a bug or am I missing something ?

Thanks in advance,
Kevin

To copy database, you should use "Transfer Database" task instead of "Transfer SQL Server Objects Task".

(I will investigate and follow-up on the issue related to appending of data in the table you are transferring.)

|||Hi Kaarthik,

I know I could use the "Transfer Database" task instead, but only in a few cases.
Most of the time I'll have to decide whether or not I want to copy certain objects (e.g. SPs) as well.

I hope this one gets fixed soon...

Another " Error: 4813 Expected the text length in data stream - "

After working for over a year, one of our snapshot replication
distributions now fails with the following error:
The process could not bulk copy into table '"texttab"'.
Expected the text length in data stream for bulk copy of text, ntext,
or image data.
(Source: DESTINATION_SERVER (Data source); Error number: 4813)
Function sequence error
(Source: ODBC Driver Manager (ODBC); Error number: S1010)
The last column of the table in error is type "text". If we lower the
number of the "BCPBatchSize" in the distribution agent profile, more
rows get copied before the error occurs - but there are too many other
very large tables in the snapshot to use that as a go-around.
As suggested in a previous post, we cannot change the table structure
because it is a third-party developed product.
When we use the -UseInProcLoader option in the dist agent, it creates
another error.
We're running SQL Server 2000 8.00.760
Thanks for any ideas.
remove the text column and replicate the remaining table. Use another method
to synchronize the text column, such as using a trigger to write to an audit
table. Have DTS read this audit table at regular intervals and then update
the text column between the publisher and subscriber. In many topologies you
will find that the text/image column is highly static.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dean" <dpichotto@.cse-insurance.com> wrote in message
news:1120071435.407646.302670@.g49g2000cwa.googlegr oups.com...
> After working for over a year, one of our snapshot replication
> distributions now fails with the following error:
> The process could not bulk copy into table '"texttab"'.
> Expected the text length in data stream for bulk copy of text, ntext,
> or image data.
> (Source: DESTINATION_SERVER (Data source); Error number: 4813)
> Function sequence error
> (Source: ODBC Driver Manager (ODBC); Error number: S1010)
> The last column of the table in error is type "text". If we lower the
> number of the "BCPBatchSize" in the distribution agent profile, more
> rows get copied before the error occurs - but there are too many other
> very large tables in the snapshot to use that as a go-around.
> As suggested in a previous post, we cannot change the table structure
> because it is a third-party developed product.
> When we use the -UseInProcLoader option in the dist agent, it creates
> another error.
> We're running SQL Server 2000 8.00.760
> Thanks for any ideas.
>
|||Thanks very much for your reply.
Wow - how twisted! I wonder if using ftp for the distribution would get
around this...

Annotations - No Copy, No Undo, No Delete confirmation?

In the Business Intellifgence studio, why can't I copy and paste an annotation, why is there no Delete confirmation, it's very easy to accidentally hit the delete option when you right click, worse still, if you do delete accidentally you can't Edit > Undo ? ..or have I missed something here?OK, i found out I can highlight the text, and use Ctrl+C on the keyboard to copy the text...no undo or delete confirmation is my main issue.

Analysis Services Question

Hi all.

I'm a new user to Analysis Services and am really stuck.

I have Cube on a local copy of SQL Server - Analysis Services (Personal Edition). I have the same Cube in a production server (Enterprise Edition).
When the cube gets rebuilt it takes about 45 minutes on my local machine and about 23 hours on the production machine. They are running with the same amount of rows in the data (13 million).

One thing I noticed is that the data is written to 9 segments of the partition on my local. And when running the process in production, it reads and writes the records alot slower, and I do not
notice any segments being written.

Is there any special setting with storage when building a Cube. I used mostly default setting on the local. I'm not sure about in Production and not sure how to check.

If anyone has any ideas on where to look or any ideas as to what could be causing this - it would be greatly appreciated.

Thanks.May check http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx for info.