Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VARCHAR(8000) - not importing
Message
De
13/01/2003 20:33:53
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
VARCHAR(8000) - not importing
Divers
Thread ID:
00741253
Message ID:
00741253
Vues:
66
Hi All,

I use the DTS manager to import data from one server to another. My problem is related to fields that are of type varchar(8000).

1) If the field in the table "does not accept nulls" and the default for the field is " " (a space) I get import errors saying the fields does not accept nulls.

2) If the field in the table "does accept nulls" and the default for the field is " " (a space) the import is successful except the data in the records is . It completely left out the data for this field.

Any ideas? Should I lower the varchar to 7999 characters, or???? Will this make a difference?

Thanks for any help,
Mike
Répondre
Fil
Voir

Click here to load this message in the networking platform