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.
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)MessagesWarning 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
b2b
Starting Member
1 Post |
|
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/ |
 |
|
|
|
|