Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server Import and Export Wizard

Author  Topic 

dtrivedi
Posting Yak Master

153 Posts

Posted - 2011-01-24 : 11:25:34
I am trying to import data using SQL server import and export wizard. It has worked like a charm each time i've done it today its giving me this error. Am I doing something wrong?


- Validating (Warning)
Messages
Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "Servername" with a length of 255 to database column "Servername" with a length of 60.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity" with a length of 255 to database column "SnmpCommunity" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity2" with a length of 255 to database column "SnmpCommunity2" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity3" with a length of 255 to database column "SnmpCommunity3" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin" with a length of 255 to database column "SSHlogin" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin2" with a length of 255 to database column "SSHlogin2" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin3" with a length of 255 to database column "SSHlogin3" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain" with a length of 255 to database column "DefaultDomain" with a length of 150.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain2" with a length of 255 to database column "DefaultDomain2" with a length of 150.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain3" with a length of 255 to database column "DefaultDomain3" with a length of 150.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "Servername" with a length of 255 to database column "Servername" with a length of 60.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity" with a length of 255 to database column "SnmpCommunity" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity2" with a length of 255 to database column "SnmpCommunity2" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SnmpCommunity3" with a length of 255 to database column "SnmpCommunity3" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin" with a length of 255 to database column "SSHlogin" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin2" with a length of 255 to database column "SSHlogin2" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "SSHlogin3" with a length of 255 to database column "SSHlogin3" with a length of 100.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain" with a length of 255 to database column "DefaultDomain" with a length of 150.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain2" with a length of 255 to database column "DefaultDomain2" with a length of 150.
(SQL Server Import and Export Wizard)

Warning 0x802092a7: Data Flow Task 1: Truncation may occur due to inserting data from data flow column "DefaultDomain3" with a length of 255 to database column "DefaultDomain3" with a length of 150.
(SQL Server Import and Export Wizard)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-24 : 11:52:39
seems like the lengths of many columns in your destination table are not sufficient for holding data from source fields. you need to tweak lengths of these fields to make it consistent with source for fixing this errors.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

b2b
Starting Member

1 Post

Posted - 2011-03-31 : 03:25:45
Hi,
You may try to found some help from the below URL. Hope it works.
http://www.sqlservercentral.com/articles/DTS/data_import_functionality_using/832/

Thanks
B2B Exporters Directory

Export Mart
info@exportmart.com
Phone: 00911204275005
Fax: 00911204275006
Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-03-31 : 04:47:08
These are just warnings as source columns length is about 255 (for all columns) but on destination side columns have capacity to hold data upto 100 or 150 character in length.

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
   

- Advertisement -