How frustrating is this, all I want to peform is a one column to one column Import here!
Why am I getting this error when simply trying to import from my excel workbook to my table? I know excel has a 255 char cell, but I specified to only account for 100 characters during the SSIS Import wizard in Management Studio. This is using SQL 2005.
See the setup here http:
Then I get this error during the import:
Validating (Error)
Messages
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.
(SQL Server Import and Export Wizard)
Warning 0x80047076: Data Flow Task: The output column "F2" (18) on output "Excel Source Output" (9) and component "Source - 'Root Levels$'" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "F1" with a length of 255 to database column "Name" with a length of 100.
(SQL Server Import and Export Wizard)
Warning 0x80047076: Data Flow Task: The output column "F2" (18) on output "Excel Source Output" (9) and component "Source - 'Root Levels$'" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - 'Root Levels$'" (1).
(SQL Server Import and Export Wizard)
My Excel doc simply has 2 columns of text, the second I'm ignoring. I am only importing the first column.
It seems to me what you are frustrated with are only warnings... the error you are receiving is this:
"Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - 'Root Levels$'" (1).
(SQL Server Import and Export Wizard)"
A couple questions for you...
1) What version/SKU of SQL Server are you using? (e.g. SQL Server 2005 Express Edition SP1)
2) Is SQL Server Integration Services also installed?
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/
I am having the same problem. I have tried importing simple CSV, Access 2003, Access 2007, and I get the same problem no matter what.
Messages
Warning 0x80047076: Data Flow Task: The output column "Column 0" (10) on output "Flat File Source Output" (2) and component "Source - ABBREV_txt" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
Warning 0x80047076: Data Flow Task: The output column "Column 1" (13) on output "Flat File Source Output" (2) and component "Source - ABBREV_txt" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
(SQL Server Import and Export Wizard)
etc...
I am running SQL Server 2005 downloaded from MSDN.
I am admin everywhere and am using windows authen and sa user w/SQL Server - both no effect.
Mel
|||SQL Server 2005 Express Edition has just been refreshed with Service Pack 2. Could you install the latest version and try again?
SQL Server 2005 Service Pack 2:
http://www.microsoft.com/sql/sp2.mspx
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
No comments:
Post a Comment