Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing data
Message
 
 
To
09/08/2011 06:43:09
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01520493
Message ID:
01520586
Views:
40
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform