Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing data
Message
 
 
À
09/08/2011 06:43:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01520493
Message ID:
01520586
Vues:
39
Open component in Advanced Editor and check column size there.

>
>
>I'm trying to create an SSIS package using the SQL Server Import and Export wizard
>
>I'm importing s csv file and am getting this error
>
>Data conversion failed while converting column "Address 1" (46) to column "Address 1" (187). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data
>IU've set the address1 to be string [DT_STR] and a width of 250
>
>Why would I be getting this error
>
>Thanks
>
>Nick
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform