Visual studio 2010 ssis
-
Hi Have a column in excel with department code like 23.45.345 I can't seem to import this column into SQL server table 2012.. trying a derived column with no joy...even tried formatting to string and SQL column is formatted to nvarchar Please help
-
Hi Have a column in excel with department code like 23.45.345 I can't seem to import this column into SQL server table 2012.. trying a derived column with no joy...even tried formatting to string and SQL column is formatted to nvarchar Please help
-
Hi Have a column in excel with department code like 23.45.345 I can't seem to import this column into SQL server table 2012.. trying a derived column with no joy...even tried formatting to string and SQL column is formatted to nvarchar Please help
Would be good to see the actual error message. Does the data that you are trying to import only have the 1 column? does the import get to a certain row number?
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
Hi Have a column in excel with department code like 23.45.345 I can't seem to import this column into SQL server table 2012.. trying a derived column with no joy...even tried formatting to string and SQL column is formatted to nvarchar Please help
SSIS has a problem importing data from Excel if the first few rows (5 I think) are in numeric format, but subsequent rows contain data that cannot be parsed as numerical. There is a way of changing the connection from SSIS to get it t not guess the column type - you need to set IMEX=1 in the connection string Check this article - [Importing data from Excel having Mixed Data Types in a column (SSIS) | Tech Updates](https://munishbansal.wordpress.com/2009/12/15/importing-data-from-excel-having-mixed-data-types-in-a-column-ssis/)
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================