DTS - Problem with Image field

DTS is not properly exporting a database between the servers when a table is containing a image field

Reason it gives as

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[Here comes the table name used ]')
Data truncation occurred in table [dbo].[Here comes the table name used ], column 1.

any workaround or solutions would be more appericated

any help would be more appericated and important to find a solution

|||

Maybe there is some image data larger than 8388602 bytes being transfered using Copy SQL Server Objects task, in this case try Import/Export Wizard instead.

And there are some other considerations you should take when using DTS to transfer BLOB data (image, text, ntext), please take a look at:

Data Conversion and Transformation Considerations

|||

that is excatly the problem , DTS truncates BLOB data and shows the error.

But how to resolve it , Iam using sql server 2000 and win xp in local server.

is BLOB data is still a issue in sql server 2000 or it is solved.

|||If you use Import/Export wizard to transfer the BOLB data (you can also save this taks to DTS package), will the same error be raised?|||

Import/Export Wizard will go to DTS package only .

Ok.

What is the command to find the sql sever installed in the system and the service pack?

Help would be appericated in getting the command

|||

Try T-SQL command:

SELECT @.@.VERSION

|||

It is showing in the sql query analyser

I wanted the command to be executed in the command prompt

and how to know the version of sp installed in the system

|||Then how about to exeute the T-SQL command in osql in command prompt|||

Can u give me the exact command.

What is the star which appears on left side along the thread

|||

Ganesh@.Nilgris:

Can u give me the exact command.

osql is a command-line utility which allows you to execute T-SQL commands So just start osql in command prompt then type T-SQL command as you can do in Query Analyzer and remember to enter "go" to submit a batch:

C:\Documents and Settings\Administrator>osql -E
1> select @.@.version
2> go

-----------------

---------------

---------------

---------------

--
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
C
opyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Wind
ows NT 5.2 (Build 3790: Service Pack 1)

(1 row affected)

|||

Thats was a good one, It was usefull in learinig sql commands in cmd prompt

But how do u still find the service pack .